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 facing an issue, I have 4 types of session volumes in two calendar years and I have displaced the values in the stacked column chart . But when I want to look at percentage of the total it calculates the percentages for two calendar year instead of calculating per calendar year . Is there a tool tip for DAX to percentage for the respective category in the calendar years ?
I would like to see percentage of each color category / total in the respective calendar year
Solved! Go to Solution.
@MaliniBaktha ,
Try this new measure and pull it into tooltip:
%Sales in a Year =
DIVIDE(
SUM('TableName'[Sales]),
CALCULATE(
SUM('TableName'[Sales]),
ALLEXCEPT('TableName', 'TableName'[Year])
),
0
)
@MaliniBaktha ,
Try this new measure and pull it into tooltip:
%Sales in a Year =
DIVIDE(
SUM('TableName'[Sales]),
CALCULATE(
SUM('TableName'[Sales]),
ALLEXCEPT('TableName', 'TableName'[Year])
),
0
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |