Using measure "Percent of Total" as a filter

[breezym5]

Hi all!

I’m calculating a percentage of total issues and the following DAX expressions give the intended result.

IssuesPerType = DISTINCTCOUNT('Data'[IssueID])

TotalIssues = CALCULATE(DISTINCTCOUNT('Data'[IssueID]), ALLSELECTED())

PercentOfTotal = DIVIDE( ‘Data’[IssuesPerType], ‘Data’[TotalIssues], 0 )

I'm also trying to filter out issues with PercentOfTotal < 1%, but when I applied PercentOfTotal as a filter the PercentOfTotal results also changed. 

Is it possible to filter out issues with PercentOfTotal < 1% without impacting the original results? 

Thank you! 

[Anonymous · Accepted solution]

Hi @breezym5 

You measure is affected by the filter, so you need to change the allselected() to all() 

You need to change your TotalIssues measure to the following.

TotalIssues =
CALCULATE ( DISTINCTCOUNT ( 'Data'[IssueID] ), ALL ( 'Data' ) )

Then it can work. 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.