topic Pct based on Type in Developer

Pct based on Type

ishzoulify — Wed, 05 Feb 2020 07:37:07 GMT

Hello Guys,

Please help on the correct DAX formula.

For example, I have this source. I just need to get the percentage of colors based on the total count.

I have seen some of the formula here but that is for numeric.

Type

Red

Blue

Green

Red

Blue

Green

Red

Total is 10

Type Count Pct

Red 5 50%

Blue 2 20%

Green 3 30%

Hope you can help.

Thanks,

Re: Pct based on Type

dm-p — Wed, 05 Feb 2020 08:25:31 GMT

Hi @ishzoulify,

I've replicated your data into a table named Colours, which is how the following examples will be written for. You can do thi sin less steps, but this is how I would approach it, as I can re-use the measures later if I need to.

Create the following measures:

# Colours = COUNTROWS(Colours)

# Total Colours = CALCULATE( [# Colours], ALL(Colours[Type]) )

The ALL removes the filter on Type, which means that for each row it will count everything.

% of Total = DIVIDE( [# Colours], [# Total Colours] )

This measure then gets formatted as a percentage.

Here's my results, with all measures shown for completeness:

Here's a copy of my workbook for your reference, in case you want to check anything.

Regards,

Daniel

If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂