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...
kmartink's avatar
kmartink
Frequent Visitor
3 years ago

tamerj1 

Here is my data sample of the Score:

 

And this is the visual:

 

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

kmartink 

I guess you are just trying to have in a card visual the count of the days that have scores less than 0.8?

if this is the case please try

Low Score =
SUMX (
DISTINCTCOUNT ( 'Table'[Date] ),
IF ( CALCULATE ( SUM ( 'Table'[Score] ) ) < 0.8, 1 )
)

  • kmartink's avatar
    kmartink
    Frequent Visitor
    3 years ago

    Hi tamerj1,

    this is the error I get when I use your formula: The SUMX function expects a table expression for argument '1', but a string or numeric expression was used.

     

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

      kmartink 
      Apologies, my mistake

      Low Score =
SUMX (
    DISTINCT ( 'Table'[Date] ),
    IF ( CALCULATE ( SUM ( 'Table'[Score] ) ) < 0.8, 1 )
)