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.
Hi all,
I don't knw if is possible but, i need to sum the result of a measure shown in a table. like this:
As you can see in the table, the result is showing 95% but is wrong, the correct ones should be 75%.
Thanks in advanc
Hi @Tahreem24 , I'm using a measure to generate those numbers
This measure:
**bleep**LOBAL = (SUM('predicciones_FV33Pack-GUADA'[Real])/CALCULATE(SUM('predicciones_FV33Pack-GUADA'[Real]),ALLEXCEPT('predicciones_FV33Pack-GUADA','predicciones_FV33Pack-GUADA'[Real])))*[FA]
The data to compose this measure is :
1 column : Measure [FA] (Is other measure no problem with that
2 column : sum row real
3 column : sum total of real
the formula would be (sum(day row day) / sum (total of real))*FA
I think my problem is that is summing all, not just the day an the the result here is 95
Any tip?
Hi @Anonymous
You may try to use below measure to get the total.If it is not your case,please check if below posts could help.If you need further help,please share some sample data which could reproduce your scenario.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Measure = SUMX ( Table, [FA])
Regards,
Any tip?
Hi,
I got the correct result as 75% in total. See the screen shot below. Please share the data type of this field.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |