DAX Measure to Show % GT

[jiexika24]

Hello, I'm seeking edits to my DAX measure.

I have a pie chart showing whether participants prefer trainings (1) In-Person, (2) Online, (3) Hybrid, or (4) No Preference. In PowerQuery, I unpivoted the column ensuring to keep all rows, so the values could be blank, 1, 2, 3, or 4. I want to ignore the blanks and calculate the % of the GT for each.

However, when I built the pie chart, it's not showing the true data, which is (1) In-person with 1 count = 7.69%, (2) Online with 9 counts = 69.23%, (3) Hybrid with 1 count = 7.69%, and (4) No Preference with 2 counts 14.38% = 100%.

Below is the DAX measure that is returning wrong data. Please see image for the output.

Online/In-Person % of GT =

VAR NonBlankRowCount =

    CALCULATE(

        COUNTROWS('Table Name'),

        FILTER(

            'Table Name',

            NOT(ISBLANK('Table Name'[Online/In-Person Unpivoted Value]))

        )

    )

VAR DistinctValueCount = DISTINCTCOUNT('Table Name'[Online/In-Person Unpivoted Value])

RETURN

    DIVIDE(DistinctValueCount, NonBlankRowCount, 0) * 100

Thanks for any suggestions!

[v-jianpeng-msft]

Hi, @jiexika24 

Can you provide some sample PBIX files? Based on your description, it's hard to model what your table will look like. Please be careful not to include private data.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li