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.
Hey i am just started working with Power BI and i am trying to get a precentage of a row total for a coulumn group that is looking at a time frame. I had no issues getting this to work for a single month but when i try to replicate this with a timeframe i am hitting a wall.
I am usining the DAX code:
Current View | |||||||||||
LOCATION | C1 | C2 | C3 | C4 | C5 | Total | |||||
L1 | 1000 | 500 | 250 | 500 | 1000 | 3250 | |||||
L2 | 1300 | 1000 | 500 | 750 | 900 | 4450 | |||||
L3 | 800 | 850 | 700 | 600 | 900 | 3850 | |||||
Wanted View | |||||||||||
LOCATION | C1 | C2 | C3 | C4 | C5 | Total | |||||
L1 | 1000.00 | 30.8% | 500.00 | 15.4% | 250.00 | 7.7% | 500.00 | 15.4% | 1000.00 | 30.8% | 3250.00 |
L2 | 1300.00 | 40.0% | 1000.00 | 30.8% | 500.00 | 15.4% | 750.00 | 23.1% | 900.00 | 27.7% | 4450.00 |
L3 | 800.00 | 24.6% | 850.00 | 26.2% | 700.00 | 21.5% | 600.00 | 18.5% | 900.00 | 27.7% | 3850.00 |
Hi @Senrsi ,
Has your problem been solved?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
In the image that you have shared, there is no mention of any time frame/slicer. Share the download link of your PBI file where one can clearly see the problem for a slicer selection. Please also show your expected result.
Hi @Senrsi ,
Is this what you want?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lionel Chen
Sorry for the delayed respones. Your solution does work for me for a single month but the issue i am having is that it is a rolling time frame that is looking back 3 months. I tried posing my power bi File to show but for some reason i am having issues with my Posting attachments.
To compare it to what you provided my table has four coulmns Location, Date, Attribute, Value
Regards
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 |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
104 | |
102 | |
88 | |
66 |