Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize values that contain false value

Hi there, I have this data: Value Ready 100 TRUE 200 FALSE 50 FALSE 175 TRUE 225 FALSE   I need to sum values that only are "FALSE" in the "Ready" column. However if I ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak Still not working. If I use data type as text and use Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = 0) ) it doesn't work

    If I use data type as it was (true/false) and use Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = FALSE()) ) it also doesn't work.

    So I think I have to make a new column with conditional formatting based on the ready column and change the "TRUE" to "Yes" and "FALSE" to "No" 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak Still not working. If I use data type as text and use Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = 0) ) it doesn't work

If I use data type as it was (true/false) and use Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = FALSE()) ) it also doesn't work.

So I think I have to make a new column with conditional formatting based on the ready column and change the "TRUE" to "Yes" and "FALSE" to "No" 

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  Anonymous 

These two measure all work well on my side.

Sum1 = CALCULATE(sum(test1[Value]) , test1[Ready] = FALSE())
Sum2 = CALCULATE(sum(test1[Value]) ,FILTER(test1, test1[Ready] = FALSE()))

Result:

and here is sample pbix file, please try it.

If you still have the problem, please share your sample pbix file for us have a test.

and "So I think I have to make a new column with conditional formatting based on the ready column and change the "TRUE" to "Yes" and "FALSE" to "No" ", it is a good solution too.

 

Regards,

Lin