Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wi11iamr
Advocate II
Advocate II

How to use a measure to to filter a page

I have created a DateKey table and linked it to my actual records. In my DateKey table I've added many colums, but also a Measure called CurrentFinancialYear. It has the value "2016", and will understandably change everytime I move into a new FY.

 

I'd like to use this measure as the filter for my pages/report, however PowerBI won't let me use a measure as a filter.

 

Is there any way in which I can use this measure to filter my report/pages?

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@wi11iamr Yes it won't let you use measure for filters. Can you not create a new column instead with same formula and that will let you use that for filters or slicers ?

View solution in original post

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

@wi11iamr Yes it won't let you use measure for filters. Can you not create a new column instead with same formula and that will let you use that for filters or slicers ?

Anonymous
Not applicable

Sorry to ask this on someone elses post, but how do you use a column (created with same formulae as the measure needed) within the Page Filter?  I cant seem to get the Page Filter to accept the column without having to hard code the duration (month for example)

@ankitpatira,

i can't use the same formula on column.

this is my measure:

me = if(CONTAINS('Query1 (2)','Query1 (2)'[combination1],[Measure 3]),1,0)

i want it contain 1 or 0 (true or false)

and to filter whthere the measure=1, but i can't use this formula to create the column

even the column = if(me=1,1,0) doesnt work. saying 'isempty' is not supported on DirectQuery.

i don't understand what's the point actually....

another thing- is there any  power bi idea to use measure as a filter that i can vote to?

 

thanks

@ankitpatira Thanks for that prompt - I included a new field in my DateKey table to calculate "IsCurrentFinancialYear", and this I then use successfully to filter on my reports.

 

Much obliged!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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