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!
Can someonple please help to know how can I manage to display the last calculated period into the total?
I imagine it is through vVriables and I have tried but I havent been able to achieve it.
This is the measure for the Cumulative Rotación vs LY %:
The one who help me with this will go to heaven!!!! Thak you in advance!!
Solved! Go to Solution.
Hi @Anonymous ,
Please new a measure like that to work on it.
new= SUMX(your table, [Cumulative Rotación vs LY Dif %] )
Hi @Anonymous,
I think you can solve it using the HASONEVALUE function, just test it with an if to change de code for total.
https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax
Ricardo
Thank you but how would type or write the measure?
Hi @Anonymous ,
Please new a measure like that to work on it.
new= SUMX(your table, [Cumulative Rotación vs LY Dif %] )
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |