Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX filter not working

I am trying to display the number of customers that fall within each revenue range.   This is the code I have right now. However, the filter does not seem to be working.  Rev Range = SWITCH ( ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello alekhved , I tried the formula but DISTINCTCOUNT only accepts one argument. It shows an error if there is more than one input

alekhved's avatar
alekhved
Icon for Resolver I rankResolver I
3 years ago

hi Anonymous 

 

My Bad!

Please try this

 

Rev Range =
SWITCH (
SELECTEDVALUE ( 'RangeTable'[Range] ),
"< $0",
CALCULATE (
DISTINCTCOUNT ( 'Table'[CustID]), [Rev_Current YTD] < 0 ),
"$0 to $100",
CALCULATE (
DISTINCTCOUNT ( 'Table'[CustID]), [Rev_Current YTD] > 0 && [Rev_Current YTD] <= 100 ),
"$101 to $500",
CALCULATE (
DISTINCTCOUNT ( 'Table'[CustID]), [Rev_Current YTD] > 100 && [Rev_Current YTD] <= 500 ),
"$501 to $1000",
CALCULATE (
DISTINCTCOUNT ( 'Table'[CustID]) , [Rev_Current YTD] > 500 && [Rev_Current YTD] <= 1000 ),
"$1001 to $1500",
CALCULATE (
DISTINCTCOUNT ( 'Table'[CustID]), [Rev_Current YTD] > 1000 && [Rev_Current YTD] <= 1500 ),
"> $1500"
)

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello alekhved ,

     

    This is the error message that I received:

    A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.