Forum Discussion

sec10's avatar
sec10
Regular Visitor
1 year ago
Solved

Different segmenter dependent value between two numbers

Dear all, 

 

First of all, my apologies due to is my first message here and I´m not sure about how it works. 

 

My question is "simple": 

 

1. I have one measure I wana call "Yes" or "No" depending on numbers I wanna filter dynamic in an segment. 

Kgs Sold between 4.60kgs to 14.00kgs = "Yes".

Rest = "No".

Segmented filter: between 4.60 and 14.00

I receive then 1.000 purchases related to and a Graphic with 1.000 "Yes" and 2.000 "No".

 

2. I wanna change the "Yes" naming, depending of the ranges I put on the segmented filter, but not changing the total of cars sold, I mean: 

 

If I change the range to: from 5 to 12 = "Yes": 

I should receive, for example, 500 "Yes" and 2.500 "No".

 

MY QUESTION IS: 

 

How could adapt the "Yes", depending of what I put on the segmented values XX between XX?

 

Thank you. 

Need Help

7 Replies

  • sec10's avatar
    sec10
    Regular Visitor
    1 year ago

    Unfortunately, instead I´m checking the message and the video, I don´t have enough knowledge to apply it on "my" issue... 

    • _AAndrade's avatar
      _AAndrade
      Resident Rockstar
      1 year ago

      Share a quick sample of data so i can take a look.

      • sec10's avatar
        sec10
        Regular Visitor
        1 year ago

        Looking at the video, my question is related to: 

        I need both Upper and Lower yellow marked values, dynamic from a slicer filter between two values. 

         

        In my case I added a column in the database table called: 

        --> "Yes" or "No" Kgs Range = IF(Sheet1[Kgs]<5.00,"No",IF(Sheet1[Kgs]>12.00,"No","Yes"))
        Then, I have a total number of "Yes" and "No". But, what I would need dynamic linked to a slicer filter would be the red values.
         
        I hope that´s enough explanation, if not please ask me. 
         
        And a BIG thank you for your help.