Forum Discussion

ZMalik1's avatar
ZMalik1
New Member
2 years ago
Solved

New Measure is removing the filter

Hi all, first time posting. I have a filter running on my dataset which takes anything as current month and above as CY else PY and I've filtered to just CY. I'm now calculating change in current w...
  • Alex87's avatar
    2 years ago

    Hello ZMalik1 ,

    the variables will hold the sum of your numeric colums. Based on your screen show I would say that

    VAR _CW = SUM('YourTableName[CW ASKs])

    VAR _PW =  SUM('YourTableName[PW ASKs])