Forum Discussion
Need help with a Card
I'm having an issue with the total count displayed in a card not changing when selecting a specific value in a Slicer. I'm using a filtered value in this card. Other cards on my page which are not using a filtered value are working just fine. Not sure how to get the card with the filtered value to work properly.
Hi Rnaval I already provided the DAX
Count of Severity = IF( ISBLANK( COUNTA('Extract'[Severity])), COUNTA('Extract'[Severity])+0, COUNTA('Extract'[Severity]))Follow the If blank, the Measure +0
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
11 Replies
Hi Rnaval
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
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/1447523Uploaded the PBIX file and the excel data...
To recreate the issue, you will notice the Card visuals titled Critical, High, Medium and Low do not change counts when the Severity Level Slicer is used to select a specific value.
Hi Rnaval
Please find the sloution pbix filehttps://drive.google.com/file/d/1JigLxqg10ry_T3KVrSVF9I-C0QvWHBdH/view?usp=sharing
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricksI'll try the pbix updates you sent, but looking at the screenshot you shared, I don't see the same options, see below.
Is there a specific email address I can use to share these files in Dropbox? Or it there another way for me to share the files on this thread?
