I have created Dashboard to display resolution reasons for the issues - it was showing exact count but when i click on the drill through issues total value count is not matching with row count- Please help me on this

[Sham_Shivan]

Query used for measures is
NonZero(
Count(
Filter(
[Issue].[Issue].Members,
([Measures].[Issues resolved],
[Resolution Reason].[Missing Files]) > 0
)
)
)

[nauris.malitis]

Hi @Sham_Shivan

Thanks for reaching out!

Instead of using such a complicated formula, please try this tuple instead:

([Measures].[Issues resolved],
[Resolution Reason].[Missing Files])

​Best regards,
​Nauris

[Sham_Shivan]

@nauris.malitis

([Measures].[Issues resolved],
[Resolution Reason].[Missing Files])

it is working …thank you @nauris.malitis

[Sham_Shivan]

need formula for story closed to release date