Forum Discussion

CEllis's avatar
CEllis
Resolver I
2 years ago
Solved

Measure not counting

Afternoon,

 

I have 2 measures that calculate if one is above or below the other.

I can get this far but for some reason it wont total the 'Movement (Up)' or Movement(Down) measures and the 'Movement (Up)' is counting all rows not just the ones that match the criteria.

 

 

Movement (Down) = 

Var _Current = CALCULATE(Average('Table1'[Result]),FILTER('Table1','Table1'[Collection]="Current"))
Var _Previous = CALCULATE(Average('Table1'[Result]),REMOVEFILTERS('Table1'[Collection]),'Table1'[Collection]=("Previouse"))

RETURN
CONVERT(CALCULATE(COUNTA('Table1'[Anon]),FILTER('Table1',_Current>_Previous)),INTEGER)

 

 

 

Example data

Table1 

AnonResultCollection
Pupil 328128Current
Pupil 345660Current
Pupil 350828Current
Pupil 350926Current
Pupil 359239Current
Pupil 360650Current
Pupil 362828Current
Pupil 363513Current
Pupil 367169Current
Pupil 375354Current
Pupil 381564Current
Pupil 382735Current
Pupil 382858Current
Pupil 3881-27Current
Pupil 391254Current
Pupil 391826Current
Pupil 3954-93Current
Pupil 396972Current
Pupil 399820Current
Pupil 4031-42Current
Pupil 411467Current
Pupil 433827Current
Pupil 436933Current
Pupil 446283Current
Pupil 3309-3Current
Pupil 3330-46Current
Pupil 37253Current
Pupil 4236 Current
Pupil 445034Current
Pupil 446410Current
Pupil 3281-1Previouse
Pupil 345643Previouse
Pupil 350823Previouse
Pupil 3509-5Previouse
Pupil 359229Previouse
Pupil 360636Previouse
Pupil 362813Previouse
Pupil 3635-11Previouse
Pupil 367128Previouse
Pupil 375316Previouse
Pupil 381561Previouse
Pupil 382734Previouse
Pupil 382822Previouse
Pupil 3881-46Previouse
Pupil 391248Previouse
Pupil 3918-2Previouse
Pupil 3954-105Previouse
Pupil 396954Previouse
Pupil 39986Previouse
Pupil 4031-65Previouse
Pupil 411442Previouse
Pupil 433816Previouse
Pupil 4369-44Previouse
Pupil 446272Previouse
Pupil 33093Previouse
Pupil 3330-36Previouse
Pupil 372537Previouse
Pupil 423657Previouse
Pupil 445037Previouse
Pupil 446434Previouse

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi CEllis ,

    I create a table as you mentioned.

    Maybe I think you can use this calculated column, here is the DAX code.

    Column = IF('Table'[Current]>'Table'[Previous],"Current","Previous")

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

     

     

     

2 Replies