Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional segmentaion based on specific value

Hi all, In a previous thread we came to this function to use conditions in order to calculate a bonus value.  Basicly if value < 8500, 0  if value < 9000, 100, 150   BonusTestM = VAR BonusMin...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    You can create a Slicer to have Person Names in then and then select the name.

    What happens when you select a person's name, doen't it filter the value on your right table for that person only?

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

You can create a Slicer to have Person Names in then and then select the name.

What happens when you select a person's name, doen't it filter the value on your right table for that person only?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11 

 

Thansk for mentioning the slicer. I tried to click the names in the small table, but that didn't work.

The slicer seems to be working with the conditions of the individual people. Only thing is, it still shows everyone's data, but just lets the function work on a single person, if that makes sense.

Here's a picture:

When I remove the measure, it only shows the selected person:

 

Also the total value is still weird, but I'll figure that out later with the HASONFITLER you mentioned.

 

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    HI Anonymous ,

     

    Is it possible to share the pbix file for this after removing any sensitive information?

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Pragati11 ,

       

      Yes this would be possible, it's currently just a test file. But I would prefer to share it in private. Can I maybe send it via private message?

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        Sure send it in a private message.