Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!!
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |