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.
