topic Re: % of total as measure in DAX Commands and Tips

% of total as measure

Anonymous — Thu, 28 Jul 2022 22:43:54 GMT

Hi there!

I have some data that looks like this:

Purchaser	Flavor	Count
Tiffany	Vanilla	20
Tiffany	Chocolate	50
Tiffany	Strawberry	30

I need to create a measure for each of the flavors to produce an output that looks like this:

Purchaser	Vanilla (%)	Chocolate (%)	Strawberry
Tiffany	20%	50%	30%

I know I can achieve this by using matrix, but I'm looking to add a bunch of other measures to one table.

Thanks so much!!

Re: % of total as measure

AUaero — Thu, 28 Jul 2022 23:11:56 GMT

Try this:

% Vanilla to Total = VAR Flavor = "Vanilla" VAR FlavorValue = CALCULATE( SUM(TestData[Count]), TestData[Flavor] = Flavor ) VAR TotalValue = CALCULATE( SUM(TestData[Count]), ALL(TestData), VALUES(TestData[Purchaser]) ) RETURN DIVIDE(FlavorValue, TotalValue)

Use this code to create measures for chocolate and strawberry by changing value of the Flavor variable.

Please accept this as a solution if it solves your problem.