The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Greetings, I have a table of positive and negative numbers,
All of the numbers are summed into rows as follows,
All I want is to have % of total of these lines, where it would divide all these individual codes by total sum of codes <599, to basically see impact of these individual codes to the overall results of codes under 599
What I would like it to look like is
Code | Grand total SUM | Grand total dax |
500 | 17861649.87 | 20823336.44 |
501 | 2053807.91 | 20823336.44 |
504 | 506468,00 | 20823336.44 |
503 | 366718.61 | 20823336.44 |
532 | 34692.05 | 20823336.44 |
Since there are positive and negative numbers in this list, the % of total function in calculation returns nonsensicle percentages, as stated in the 4th collumn
These are the DAX commands I am using,
Solved! Go to Solution.
Hi @srbs , try these measures (almost same, just a little different):
_Grand total SUM = SUM(t[Grand total SUM])
Grand total dax = CALCULATE ( SUM ( t[Grand total SUM] ), t[Code] < 599, ALL ( t ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Hi @srbs , try these measures (almost same, just a little different):
_Grand total SUM = SUM(t[Grand total SUM])
Grand total dax = CALCULATE ( SUM ( t[Grand total SUM] ), t[Code] < 599, ALL ( t ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
That works indeed, thank you,
I think I solved it aswell on my own with one uneccesary extra step
And I wanted to mention that I overlooked like 10 different youtube videos on the matter and the solutions work there but not in my dax for some reason
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |