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 criterion <1000. It works, but I don't get a total at the bottom.

 

The measure: Sales Test= SWITCH(TRUE(),ISINSCOPE(Customer_V[No]),Sales[Sales],Sales[Sales])
the measure must be calculated on Customer_V[No] dimension.

Sales[Sales] = is a "sum" measure.

 

 

  • 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]))

6 Replies

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        Arslan94 

        I'm a little bit confused

        this is your measure 

        Sales Test= SWITCH(TRUE(),ISINSCOPE(Customer_V[No]),Sales[Sales],Sales[Sales])

        this basically returns the same value in both conditions! is thi a typo mistake? how did you blank out the first two values?