need help please !!!

[Arslan94]

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.

[tamerj1]

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

[Arslan94]

Hi @tamerj1 

i slicing the Customer no. 

[tamerj1]

@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]

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 · Accepted solution]

hello try to use this on the measure you did:

IF(HASONEFILTER([customer no]),[your measure],SUMX(VALUES([customer no]),[your measure]))

[Arslan94]

Unbelievably, THANK YOU SO MUCH!!! @Anonymous