Forum Discussion

AxelKAp's avatar
AxelKAp
Icon for Helper I rankHelper I
3 years ago

Help on a SWITH() and SELECTEDVALUE() formula

Hi everyone,  I need your help to set up a DAX formula to filter by thresholds. I have a table where you can find all the invoice informations, below you can find how the tha table is build: ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi AxelKAp 

what is your expected result, based on your sample data?

AxelKAp's avatar
AxelKAp
Icon for Helper I rankHelper I
3 years ago

Hi FreemanZ ,

With my sample data, I would like to filter by spend thresholds.
Example, if I filter by "<10K€", I will only have the suppliers with a Total Spend "<10K€", here I will have only supplier B.