Forum Discussion

kmartink's avatar
kmartink
Frequent Visitor
3 years ago

A measure using IF condition with a column reference

Hi, I'm using a slicer filtering the weeks and have made this measure to calculate how many days in a selected week was a score below 80%.   Low Score = IF(     CALCULATE(SUM('Table'[Score]))>=0...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi kmartink 

make sure you have created a measure not a calculated column by mistake 

kmartink's avatar
kmartink
Frequent Visitor
3 years ago

Hi tamerj1,

 

yes what I've created is a measure. I was wondering if the problem might be caused either by that the formula accidentally summarizes all the rows of the "Score" column which would mean the result would be always higher than 80% and so the zero will be displayed? Or either that my "Score" has the Data type "decimal number" and the format "percentage" but the formula uses "0.8" for 80%?

 

Is there any other way how to rewrite the formula so it might not be accidentally summing up all the rows of the column "Score" if that's the case what's happening right now? I already tried to use "AVERAGE" instead of "SUM" but there wasn't any difference. Thanks.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    kmartink 
    Would you please present sample fo the data and perhaps a screenshot of the visual?