cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmills2018
Helper IV
Helper IV

Issue with Data Slicer

Hello,

 

i have a slicer for Month/year, when i filter this slicer i am expecting my data to pull for the appropriate month selected.  Some of my data are measures with a date calculation (the date table is unrelated).  The issue I am running into, is that my data is only pulling YTD, so when i filter for June the data looks good but when i filter for May, it still keeps my June data.  below is my measure, any ideas what i am doing wrong?  I am assuming it has to do with a relationship of the filter?

 

 

Stage 4a Actual test =
var maxmonth= LASTDATE('Consolidated Talent Snapshot (2)'[Data as of])
return
CALCULATE(DISTINCTCOUNTNOBLANK('Consolidated Talent Snapshot (2)'[Associate ID]), 'Consolidated Talent Snapshot (2)'[In Talent for Job Family]="true", maxmonth)+0
4 REPLIES 4
HashamNiaz
Super User
Super User

Hi @mmills2018 !

 

Please make following changes to your DAX code;

 

Stage 4a Actual test =
var maxmonth= MAX('Consolidated Talent Snapshot (2)'[Data as of])
return
CALCULATE(DISTINCTCOUNTNOBLANK('Consolidated Talent Snapshot (2)'[Associate ID]), 'Consolidated Talent Snapshot (2)'[In Talent for Job Family]="true", maxmonth)+0

 

Regards,

Hasham

Hi @mmills2018 !

 

Lets try to simplify DAX a bit and use following;

 

Stage 4a Actual test =
var maxmonth= MAX('Consolidated Talent Snapshot (2)'[Data as of])
return
CALCULATE(DISTINCTCOUNTNOBLANK('Consolidated Talent Snapshot (2)'[Associate ID]), FILTER('Consolidated Talent Snapshot (2)', 'Consolidated Talent Snapshot (2)'[Data as of = maxmonth)) + 0

 

I have removed the filter for Job Family, please check if the above DAX works, we can append that filter back again.

 

Regards,

Hasham

Hi Hasham,

 

did you get a chance to look into this?

thanks, when i change 'lastdate' to 'Max" i get the below error2021-06-22_8-47-50.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!