I have written the following Dax, but do not understand what's missing: Bucket Gross Value =SWITCH(TRUE(),‘Fact’[Gross Value] <=10000,"under 10'000",‘Fact’[Gross Value] > 10000 &&’Fact’[Gross Value] <=100000,"< $100'000",‘Fact’[Gross Value] > 100000 &&’Fact’[Gross Value] <=500000,"< $500'000",‘Fact’[Gross Value] >500000 &&’Fact’[Gross Value] <=1000000,"< $1’000'000",‘Fact’[Gross Value] >1000000 &&’Fact’[Gross Value] <=500000000,"< $500’000’000", ‘Fact’[Gross Value] >500000000 &&’Fact’[Gross Value] <=1000000000,"< $1’000’000’000",‘Fact’[Gross Value] >1000000000 &&’Fact’[Gross Value] <=50000000000,"< $50’000’000’000","> $50’000’000’000”) I know there are differnt ways to do it, but I have to do it with a Switch at the moment. It seems as if the else statement is faulty, but I don't see whats wrong.

tamerj1 Thank you very mich for your answer. The "$100'000" act like a text in this context. Therefore, as such the apostrphe can remain. It turned out the problem was that it was not in direct query. Once in direct query ot worked fine. Thank you.

acg

Resolver I

4 years ago

Solved

Bucketing values - what is missing?

I have written the following Dax, but do not understand what's missing:

Bucket Gross Value =

SWITCH(

TRUE(),

‘Fact’[Gross Value] <=10000,"under 10'000",

‘Fact’[Gross Value] > 10000 &&’Fact’[Gross Value] <=100000,"< $100'000",

‘Fact’[Gross Value] > 100000 &&’Fact’[Gross Value] <=500000,"< $500'000",

‘Fact’[Gross Value] >500000 &&’Fact’[Gross Value] <=1000000,"< $1’000'000",

‘Fact’[Gross Value] >1000000 &&’Fact’[Gross Value] <=500000000,"< $500’000’000",

‘Fact’[Gross Value] >500000000 &&’Fact’[Gross Value] <=1000000000,"< $1’000’000’000",

‘Fact’[Gross Value] >1000000000 &&’Fact’[Gross Value] <=50000000000,"< $50’000’000’000","> $50’000’000’000”

)

I know there are differnt ways to do it, but I have to do it with a Switch at the moment. It seems as if the else statement is faulty, but I don't see whats wrong.

acg
4 years ago
tamerj1 Thank you very mich for your answer. The "$100'000" act like a text in this context. Therefore, as such the apostrphe can remain.
It turned out the problem was that it was not in direct query.
Once in direct query ot worked fine.
Thank you.

Forum Discussion

Bucketing values - what is missing?

6 Replies

Related content

Sales bucket with bucket values set by slicer

Total value missing in calculated column

missing data

Generating Missing Data

Inferring Missing Columns and Imputing Missing Data