The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I am tring to apply a filter to a measure, I am not sure how i do that.
In the screenshot below i need to view "Varience to Target Gross Utz" <10, which is a measure.
Thanks in advance.
Thanks,
Srini
Solved! Go to Solution.
@vishwanathans , Apply using the visual level filter
Or create a measure like
Example
AverageX(filter(Values(Table[Employee Name]),[Varience to Target Gross Utz] <10),[Measure])
@vishwanathans - You can add a measure to the Filters pane just like a column. You can do this only at the Visual level, not the Page or the Report level.
@vishwanathans , Create a visual level filter or measures like
example
AverageX(filter(Values(Table[Employee Name]),[Varience to Target Gross Utz] <10),[Measure])
@vishwanathans , Apply using the visual level filter
Or create a measure like
Example
AverageX(filter(Values(Table[Employee Name]),[Varience to Target Gross Utz] <10),[Measure])