Sum column by filter

[Babycakes]

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

[Anonymous · Accepted 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

[Chew_WenJie]

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.

[Babycakes]

still giving me same outcome of 4.67 😞