Forum Discussion
Fix % when using slicer.
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 a small change in the second measure
Status 1 Count = CALCULATE ( COUNTROWS ( ComplianceData ), filter(ComplianceData, ComplianceData[Status] = "Compliant" ))
% Compliant = DIVIDE ([Status 1 Count] , [All Records] )
2 Replies
ElvirBotic , Try with a small change in the second measure
Status 1 Count = CALCULATE ( COUNTROWS ( ComplianceData ), filter(ComplianceData, ComplianceData[Status] = "Compliant" ))
% Compliant = DIVIDE ([Status 1 Count] , [All Records] )Awesome that seemed to work. I do have a question when using the slicer to slice by different status' I have a matrix table with different DAX measures as columns and rows are broken into categories so I am able to get different % based off categories.
When using the slicer it filters the matrix table and will show 100% when the original value was 8%. I understand I am telling it to show only records with "non compliant" data, but I would want to be able to see it still as the original and not 100%
