DAX() Created but Drill through not working

[Anonymous]

Hello Team,

Below DAX() Created but Drill through not working.

DAX():  

var maxweeknumber1= max('unique records'[week num_unique])

var count1= CALCULATE(COUNTROWS('unique records'),filter('unique records','unique records'[week num_unique]=maxweeknumber1))

return count1

Note: Above DAX showing currect value in Card / Bar not working on drill through 

[Anonymous · Accepted solution]

Hi Team,

I tried like for below DAX it's working fine now drill through also.

DAX:

No of compliant programs = CALCULATE(COUNT('unique records'[Program Name]),FILTER('unique records',YEAR(NOW())=YEAR('unique records'[Modified]) && WEEKNUM(NOW())-1='unique records'[week num_unique]))

Thansk,

Ravi

[Anonymous]

Hello Team,

Please help me resolve this issue.

Thanks, 

Venkata.