Forum Discussion

AndrewPF's avatar
AndrewPF
Icon for Helper V rankHelper V
3 years ago

Why does a slicer not affect a measure?

I have the following measure:  Risks In Progress = if(calculate(sum('Risks Registers'[Risk Count]), 'Risks Registers'[workflowStageName] <> "Closed") = 0, 0, calculate(sum('Risks Registers'[Risk ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

AndrewPF , Not very clear. Try measure like

 

calculate(sum('Risks Registers'[Risk Count]), filter('Risks Registers', 'Risks Registers'[workflowStageName] <> "Closed"))

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.