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,
I am using following measure and used it in "Total" column in a table:
I want to add one more column in the same table to show the %. I am able to do it in Excel:
I need help to achieve the same in PBI.
Solved! Go to Solution.
You can create a measure like
% =
VAR CurrentValue = [# cases]
VAR Total =
CALCULATE ( [# cases], ALLSELECTED ( 'Table'[Client] ) )
RETURN
DIVIDE ( CurrentValue, Total )
You can create a measure like
% =
VAR CurrentValue = [# cases]
VAR Total =
CALCULATE ( [# cases], ALLSELECTED ( 'Table'[Client] ) )
RETURN
DIVIDE ( CurrentValue, Total )
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |