Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |