Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ignore Visual level filter in measure

Hi wonderful PBI community,   I am unsure if this is possible but thought I would ask.   I have a measure that calculates a total bonus earnt and I use a visual level filter to taylor this to the...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

If you add measure [total bonus earnt] to the visual filter, when applying a filter, it will change the rows for all columns shown in the same visual.

If you add a column or other measure to the visual filter, to ignore visual level filter in measure [Team Bonus], we need to consider if the column affects the measure [Team Bonus].

So we need know how  the measure [Team Bonus] calculate and which columns it uses and what's relationship between these columns and the column used the visual filter.

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-juanli-msft,

     

    [Team Bonus] is made up of [Team Conversion]+[Team GP], these are both Look Up's like the formula above, they look up based on the result of the [Team GP] that adds up GP Columns from the 'Sales Data' table, based on the invoice number from the 'Sales Team Sales' table. How ever this is also filtered by 'user' to give us the [Individual GP] result and [Individual Conversion] result. So I would like the Result of a filtered [Individual Bonus] measure added to an unfiltered [Team Bonus] measure. 

     

    Regards,

    Dave.