Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have created a measure that calculates a oercentage with a filter. i have the same filter in my table visual but i want to ignore the filter that is in the visual and apply the filter in the measure.
example:
accessories achievement = calculate(achievement * .1 , category[type]= accessories, all(category[type))
my table visual should show the below
category | type | core achievement | accessories achievement |
gross aad | core | 94 | 8 |
renewal | core | 90 | 7 |
note: there's a filter on page level for the column type=core. i want to show accessories achievemnet with type= accessories ignoring this page level filter= core.
currently with the measure i created above, accessories achievement is showing blank.
Hi @lawadaa
Assuming "Accessories" type do exist in the specified categories, please try
Accessories Achievement =
CALCULATE (
[Achievement] * 0.1,
ALL ( Category ),
VALUES ( Category[Category] ),
Category[type] = "Accessories"
)
Interactions can be edited between the filter that is in the visual and the measure table.
the filter is in the filter pane and not in the page. interaction cant be applied as the filter is on the same column it's just that i want to filter the value in the column