Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello friends,
I am trying to calculate a running total based on orders table.
I get wierd result. please check and help. i would like to get the running total based on category wise sales.
here is the link to my powerbi file:
https://1drv.ms/u/s!ArDdiHvYfT0RgYwqe2eHCo64tUXfIg
Regards,
Pradip
Solved! Go to Solution.
Hi, try with this:
Total sales running = VAR TOT = CALCULATE ( SUM ( Orders[Sales] ) ) RETURN CALCULATE ( [Total sales], FILTER ( ALLSELECTED ( 'Products2'[Sub category] ), [Total sales] <= TOT ) )
Regards
Victor
Lima Peru
Hi Victor,
Thanks for the solution. It did work. Thanks again for that. just a simple question,
I am trying to understand that function when removed the variable syntax and tried to do without it doesnt work, could you kindly explain? and why do we have to write calculate twice?
The Var made a Calculate of Total Sales in this context. (Current Subcategory)
So The Filter Search all The Subcategories with "Total-Sales" Lower than the Total Sales of Actual Subcategory.
If you put directly in the filter its saying total Sales (Measure) are equal to Sum of Total Sales .
Hi, try with this:
Total sales running = VAR TOT = CALCULATE ( SUM ( Orders[Sales] ) ) RETURN CALCULATE ( [Total sales], FILTER ( ALLSELECTED ( 'Products2'[Sub category] ), [Total sales] <= TOT ) )
Regards
Victor
Lima Peru
Hi Victor,
Thanks for the solution. It did work. Thanks again for that. just a simple question,
I am trying to understand that function when removed the variable syntax and tried to do without it doesnt work, could you kindly explain? and why do we have to write calculate twice?
The Var made a Calculate of Total Sales in this context. (Current Subcategory)
So The Filter Search all The Subcategories with "Total-Sales" Lower than the Total Sales of Actual Subcategory.
If you put directly in the filter its saying total Sales (Measure) are equal to Sum of Total Sales .
Thanks Victor,
That helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |