Skip to main content
cancel
Showing results for 
Search instead 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

Reply
maurcoll
Helper II
Helper II

Filtering with a measure

Good Afternoon,

 

I have the below measure for calculating if an employees training is still valid after a selected date.


training_valid=

 VAR _SelectedDate = max('Date'[Date])
  VAR _Result = IF( MAX('employee_training'[training_expiry_date])>= _SelectedDate, "Valid", "Expired")
 
  RETURN
  _Result


This works perfectly well, what i now want to be able to do is create a card/measure for the number of employees that are working on the selected date and also where the training is valid.
I cant seem to add the above measure in as a filter on a card or a table if iuse a measure of 
 
Total Working=
Calculate(
distinctcount ('employee'[employee_number]),
'employee_rota'[rota] = "working")

Is it possibe to filter using the measure for valid training
 
Thank you
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@maurcoll You should be able to add a measure in the Filters pane at the visual level.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@maurcoll You should be able to add a measure in the Filters pane at the visual level.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi I need to appy the filter to a card visual, it does not let me do this. This is all i see and it does not let me enter anything into the contains box.

maurcoll_0-1716279713413.png

 

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors