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 )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
28 | |
24 | |
22 |