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...
Need Help
  • Alex87's avatar
    Alex87
    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])

ZMalik1's avatar
ZMalik1
New Member
2 years ago

Hi Alex,
Thank you very much for that, I get what you mean and you're absolutely right.

 

Thanks for sharing the code, I seem to get a reference error -

 

So I tried to replace "cw" with the actual column name which is cw asks and the same for pw but seems to still throw it out and doesnt pick up the column, you can what results it finds instead and also showing the second from the end 3rd and 2nd column that are the reference points as guidance -

 

Thanks for your help!