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,
This is probable really simple but I just cant get it.
I dont want to sum ratio in general but I want a sum at the bottom that shows on day 5 after filtering the ratios added up is 2.999
or 3 rounded vs 4 staff?
I want to be able to then filter that this serivce is over staffed as 4 staff to ratio 3 required?
What am I missing? If i sum ratio it adds all ratios in the column which is incorrect as I am getting 4.67 based on other data?
Second image is correct
Solved! Go to Solution.
HI @Babycakes ,
I've using a different set of sample data, but you get the concept below:
Step 1 : Create a measure ,
Measure =
IF(
HASONEVALUE(Sheet1[Sum of Ratio]),
CALCULATE(
SUM(Sheet1[Sum of Ratio])),""
)
Step 2: Put Measure to Matrix
If that helps, please mark this as a solution
BR
Dax_Noob
HI @Babycakes ,
I've using a different set of sample data, but you get the concept below:
Step 1 : Create a measure ,
Measure =
IF(
HASONEVALUE(Sheet1[Sum of Ratio]),
CALCULATE(
SUM(Sheet1[Sum of Ratio])),""
)
Step 2: Put Measure to Matrix
If that helps, please mark this as a solution
BR
Dax_Noob
Hello, maybe you can try to use measure to sum the value. For example,
Measure = SUMX('Table' , [ratio])
Hope this method is able to help you.
still giving me same outcome of 4.67 😞
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |