Forum Discussion

ElvirBotic's avatar
ElvirBotic
Helper III
4 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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] )

amitchandak's avatar
amitchandak
Super User
4 years ago

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] )

ElvirBotic's avatar
ElvirBotic
Helper III
4 years ago

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%