Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
i'm new to PowerBI and have a question:
I'm working with a 6 level deep parent-child hierarchy and depending on the level, the entries must be multiplied with a specific weight. The weights of a Level should not be summed up with the weights of the respective upper Level, because the upper one has its own specific weight.
You can see the desired outcome in the last column of the example table on the right.
In the "Weight" Column is the data, as it gets displayed (summed) without any further measures. I already tried to use "Dont summarize" but this isnt working.
In the "Weight Level 1" Column the summing for Level 1 is supressed with a specific measure:
Thanks in advance for helping me!
MZW
Hi @MZw ,
I think this is feasible. Or use switch to write this function. Write the 5 formulas together. Essentially there is no difference.
Best Regards
Community Support Team _ chenwu zhu
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |