Forum Discussion

Arslan94's avatar
Arslan94
Frequent Visitor
3 years ago
Solved

need help please !!!

hello i am new on the platform and i hope you can help me.   the following problem:   I want to write a measure that should refer to the "SalesTest" measure and give me the total with the criteri...
  • Anonymous's avatar
    Anonymous
    3 years ago

    hello try to use this on the measure you did:

    IF(HASONEFILTER([customer no]),[your measure],SUMX(VALUES([customer no]),[your measure]))
Arslan94's avatar
Arslan94
Frequent Visitor
3 years ago

Sorry,

tamerj1 

 

SalesTest is the measure with the criterion <1000.

SalesTest: if(salesTest < 1000,salesTest)

And Sales is the measure : SWITCH(TRUE(),ISINSCOPE(Customer_V[No]),Sales[Sales],Sales[Sales])

Anonymous's avatar
Anonymous
Not applicable
3 years ago

hello try to use this on the measure you did:

IF(HASONEFILTER([customer no]),[your measure],SUMX(VALUES([customer no]),[your measure]))
  • Arslan94's avatar
    Arslan94
    Frequent Visitor
    3 years ago

    Unbelievably, THANK YOU SO MUCH!!! Anonymous