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]))
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Arslan94 
What are you slicing by in the table visual? 

Arslan94's avatar
Arslan94
Frequent Visitor
3 years ago

Hi tamerj1 

 

i slicing the Customer no. 

 

  • 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?

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