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 everyone,
i have sample super store table. and i calculated "Actual Sales". now i wanted to show "Actual sales" %contribution for each status on particular year.
can any one help on this. data provided in this link.
.
Thanks in advance
regards
venu
Solved! Go to Solution.
Hi @Anonymous ,
Please try the measure below.
Measure 2 = VAR totalforeachyear = CALCULATE ( SUM ( 'Table1'[Actual sales] ), ALLEXCEPT ( Table1, 'Table1'[Year] ) ) VAR salesforeachstatus = CALCULATE ( SUM ( 'Table1'[Actual sales] ), ALLEXCEPT ( Table1, Table1[Status_], Table1[Year] ) ) RETURN salesforeachstatus / totalforeachyear
Here is the output.
More details, please refer to my attachment.
Best Regards,
Cherry
Looks like you need
a) a measure to SUM [Actual Sal] taking into account Year and Status.
b) a measure to SUM [Actual Sal] taking into account Year
Then DIVIDE a by b
That should give you a start
Hi @Anonymous ,
Please try the measure below.
Measure 2 = VAR totalforeachyear = CALCULATE ( SUM ( 'Table1'[Actual sales] ), ALLEXCEPT ( Table1, 'Table1'[Year] ) ) VAR salesforeachstatus = CALCULATE ( SUM ( 'Table1'[Actual sales] ), ALLEXCEPT ( Table1, Table1[Status_], Table1[Year] ) ) RETURN salesforeachstatus / totalforeachyear
Here is the output.
More details, please refer to my attachment.
Best Regards,
Cherry
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 |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |