Percentage of the "bersih" and "Tak bersih"

[Anonymous]

Hi.

I need some help creating a measure to calculate the amount of "Bersih" answers in a column with "Bersih" and "Tak Bersih". I will use that result as a percentage in monthly bar chart. I want it to be the percentage of the various R&R  by "kebersihan meja" and "kebersihan lantai" so I can create the total score of Bersih like this.

Any ideas? I´m totally new to DAX. I´ve tried DIVIDE (COUNT([column name] = 'Bersih'; COUNT([column name])) and

% Bersih Meja =

DIVIDE (

CALCULATE ( COUNT ( Sheet1[Kebersihan Meja] ), Sheet1[Kebersihan Meja] = "Bersih" ),

CALCULATE ( COUNT ( Sheet1[Kebersihan Meja] ), ALLSELECTED ( Sheet1[Kebersihan Meja] ))).

Thank you in advance for you kind help and very very apreciate it.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

According to your description, You can modify your measure.

Like this:

% Bersih Meja =
DIVIDE (
    CALCULATE (
        COUNT ( Sheet1[Kebersihan Meja] ),
        Sheet1[Kebersihan Meja] = "Bersih"
            && Sheet1[Kebersihan Lantai] = "Tak Bersih"
    ),
    CALCULATE (
        COUNT ( Sheet1[Kebersihan Meja] ),
        ALLSELECTED ( Sheet1[Kebersihan Meja] )
// COUNT ( Sheet1[Kebersihan Meja] )
    )
)

Not sure what your expected result looks like, please explain if it is not right.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Community Support Team _ Janey

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.