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.
How can I use this Total highlighted below in another Measure/Calculation?
This is my measure
The next step is to divide this Total number by how many months make it up which I have done inside the measure unfortunately it divides each row by the total number of months instead of just the total 😞
Hi,
I am unsure about the Months Calculation that you have mentioned, But if you require to divide the Total SUM then use the calculation :
CALCULATE(SUM(Rolling_Sum),ALL(Table_Name))
Will do thanks. I think I got my answer anyway
Hi,
Please always prvoide some sample data in either text or table format along with snippets. A snippet doesn't alow the users to copy the data readily and and do a qucik analysis.So it may reduce the probability of your question being answered.
Regards,
Ananth
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
41 | |
27 | |
21 |