cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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 individual. It's a simple measure Total Bonus = [Individual Bonus]+[Team Bonus], the tricky bit is I need the measure [Team Bonus] to ignore the visual level filter I place on the measure. Is this possible?

7 REPLIES 7
Community Support

Hi @DaveBFT

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

Frequent Visitor

[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.

Memorable Member

Hi @DaveBFT,

It is possible.

You need to modify [Total Bonus] measure. I would suggest to use ALL() in your CALCULATE() to remove context of filter you are applying in visual level filter.

Check this link for syntax of ALL().

Prateek Raina

Frequent Visitor

Hi, Thanks. I guess I need to be more clear around these measures. Team Bonus is made up of [Team Conversion]+[Team GP] and those measure are look up values on a table for e.g

Team Conversion =
CALCULATE(
LOOKUPVALUE('Bonus Payments'[Team Conversion \$\$],'Bonus Payments'[Team Conversion],
ROUNDDOWN('Sales Measures'[Conversion],2)))+0

This is so I can edit the spreadsheets easily when the targets change. SO I am struggling to an ALL into this.

Frequent Visitor

Hi

I have 17 Seperate data tables and 4 seperate tabes of measures.  However the only relationship in effect here is the User table and the Sales Data table.

I donlt think what I am trying to do is possible so I will need to figure out a different way to calculate the bonus figures.

Frequent Visitor

Hi

I have 17 Seperate data tables and 4 seperate tabes of measures.  However the only relationship in effect here is the User table and the Sales Data table.

I donlt think what I am trying to do is possible so I will need to figure out a different way to calculate the bonus figures.

Memorable Member

Hi @DaveBFT,

Can you screemshot your relationship between tables and also tell which column are you using in the visual level filter.

After this input only, we will be able to tell that where you should change to accomplish the result.

Prateek Raina

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors