Forum Discussion

MichaelNiederer's avatar
MichaelNiederer
New Member
10 months ago
Solved

Switch function not working with a slicer

I have a Customer Sales Table with a sum (netSum = SUM(...)) and compare it with a sum of previous time period: netSumPrev = CALCULATE(      [netSum],      ALL ( 'Date(Sales)' ),      USERELAT...
Need Help
  • MFelix's avatar
    MFelix
    10 months ago

    Hi MichaelNiederer ,

     

    The problem is that you have created a column on your model instead of a measure you create the following measure:

     

    Prev_Selection_SwitchCG _1 = 
SWITCH(TRUE(),
[NetSumPrev] >= MIN(CategoryDelNotes[Min]) && [NetSumPrev] < MAX(CategoryDelNotes[MAXREVISED]), 1)

    Now you should be able to get the result you need.

     

    Be aware that since your max value is blank I created a new column replacing blank by 9999999999

     

    Now if you use this measure on your visual you are able to get the expected result:

     

     

    If you just filter out the blanks you get the following result the bottom table is the one with the filter applied:

     

     

     

    Please see file attached.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
10 months ago

Hi MichaelNiederer ,

 

For this you need to have a table with the buckets and the switch statement, however you do not refer how that part of your model is.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.