Forum Discussion

mmills2018's avatar
mmills2018
Icon for Helper IV rankHelper IV
5 years ago

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...
Need Help
HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

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

  • mmills2018's avatar
    mmills2018
    Icon for Helper IV rankHelper IV
    5 years ago

    thanks, when i change 'lastdate' to 'Max" i get the below error

  • mmills2018's avatar
    mmills2018
    Icon for Helper IV rankHelper IV
    5 years ago

    Hi Hasham,

     

    did you get a chance to look into this?

  • HashamNiaz's avatar
    HashamNiaz
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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