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
jakemorris606
Frequent Visitor

Filtering Visual with DAX

Hello,

 

i have create a dashboard to show which contractors are on site daily - the table at the bottom is a filtered by a DAX function which returns the value 1 if the contractos fall within with the range today (TODAY()) so which morning when its refreshed the table is updated the contractors in today! - this works perfectly . 

 

however i want to use the same prinipcals for visuals  (PieCharts / Synopic Panels etc) but when use this same DAX in the filter it returns all the values as '0' - and no data is vailable unless i set the filter to is = 0 then it show all data in the entire data set.

 

my  DAX ;

 

Is displayed =
var _date = TODAY()
var _startdate = SELECTEDVALUE('Contractor Jobs'[Arrival Date])
var _enddate = SELECTEDVALUE('Contractor Jobs'[Last Day Of Attendance])
return
IF(_date>=_startdate&&_date<=_enddate,
1, 0
)
 
 
 
jakemorris606_1-1658396896870.png

 

if anyone could offer any support i would be very greatful ,

 

 
kind regards,
jake 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@jakemorris606 , Try a measure like

 

countrows(filter('Contractor Jobs', 'Contractor Jobs'[Arrival Date] <= Today() && 'Contractor Jobs'[Last Day Of Attendance] >= Today()))

View solution in original post

2 REPLIES 2
jakemorris606
Frequent Visitor

Thank you Amitchandak!.

amitchandak
Super User
Super User

@jakemorris606 , Try a measure like

 

countrows(filter('Contractor Jobs', 'Contractor Jobs'[Arrival Date] <= Today() && 'Contractor Jobs'[Last Day Of Attendance] >= Today()))

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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