Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi guys,
I want to create a measure that multiplies column "C&OCalaculate" with 100 if Column "VullingtotaalPerc" = "100 %".
the measure should look something like this: if Column "VullingtotaalPerc" = "100%" then multiply Column "C&OCaluculate" with 100 +
if Column "VullingtotaalPerc" = "40%" then multiply Column "C&OCaluculate" with 40 and so on.
I've tried to use the If-statement but I can't choose any columns because they are not a measure (??)
thnx guys!!
Hi Mahesh,
This worked! Thank you so much, but now I've have another problem.
I can't figure out how to get the grand total.
I've created a measure called "IF_cond C&O-calculated".
Example: This measure will multiply column "C&O-Calculated%" with 100 if the column "VullingTotaalPerc" is 100 %.
The measure is working fine but it won't show a grand total of percentage.
Down below is the measure:
User | Count |
---|---|
82 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
105 | |
97 | |
86 | |
68 |