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" 

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Try like

Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = FALSE()) )

Sum1 = CALCULATE(sum(test1[value]) ;filter(test1, test1[Ready] = 0) )

 

What is Data type , if it showing as of now

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
    Community 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