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 All,
I have a table 'Product' that includes columns [Date], [Product] and related table 'Calendar' that includes columns [Date], [Year], relation is one-to-many
I want to calculate the percentage of the total column by DAX in this way:
Despit of diminsions If I select vertically or horizontally, it should calculate the percentage of Column total, like shown in the pictures above
I'm using PowerPivot for Excel 365 (not Power BI)
Thanks in advance.
drag the units (again) into the values section, right-click and go to Value Field Settings > Show Values As > % of Column Total.
Dear
As per the current situation, I need a measure to calculate it.
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 |
---|---|
87 | |
86 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |