Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
hello, Power BI Community,
I am running into a problem I have not seen before. I was given an Excel file with roughly 1200 records. The goal is to calculate the % compliant. There is a column in the dataset that gives a status to each record. I have a few DAX measures to calculate the %.
All records = COUNTROWS ( ComplianceData )
Status 1 Count = CALCULATE ( COUNTROWS ( ComplianceData ), ComplianceData[Status] = "Compliant" )
% Compliant = DIVIDE ( Status 1 Count , All Records )
I have other DAX measures for each of the 4 different status but I am going to use the compliant status as an example.
My problem is when I add in a slicer to slice by different status' how do I show the correct % based on that selection instead of displaying a result of 20,000% I know what is happening as it is dividing the "All Records" amount by the amount selected in the slicer, but I just do not know how to fix it to display correctly.
@ElvirBotic , Try with few changes in second measure
Status 1 Count = CALCULATE ( COUNTROWS ( ComplianceData ), filter(ComplianceData, ComplianceData[Status] = "Compliant" ))
% Compliant = DIVIDE ([Status 1 Count] , [All Records] )
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 63 | |
| 51 | |
| 41 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 130 | |
| 111 | |
| 48 | |
| 30 | |
| 28 |