Forum Discussion
Count value showing based on condition
Have a report like above.Dataset is below shown one is using
.
If a user is click on yes, count of state req should be calculate only for country where reason value not in Risk Area and Risk
If a user is click on no,count of state req of all the data should be calculated...
Is there any way to do ?
2 Replies
Hi Anonymous , try this measure:
Count of State = if (MAX(Table2[Column1])="Yes", CALCULATE(count('Table'[State Req]),'Table'[Reason]<>"Risk" , 'Table'[Reason]<>"Risk Area"), count('Table'[State Req]) )The result:
Best Regards
yes, this can be done with measures as visual filter. Note that your slicer probably should be set to single select, otherwise users can select both yes and no, or neither.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
