Forum Discussion

acg's avatar
acg
Icon for Resolver I rankResolver 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...
  • acg's avatar
    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. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

acg 

This is the error

 

acg's avatar
acg
Icon for Resolver I rankResolver I
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.