Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
5 years ago

URGENT - dax function not working

Hi all,   I have the month slicer, I was trying to calculate how many people activated at the begining of the seleced month. For example: when I selected April, I want to know how many people was u...
Need Help
xiumi_hou's avatar
xiumi_hou
Post Partisan
5 years ago

Thanks Jihwan_Kim  The below query can return the result. The only thing is I have active relationship built for case table(assigned date) with the date table (date). - This can not be removed since a lots of other querys are based on this.  Do I need to made any changes? 

Angith_Nair's avatar
Angith_Nair
Continued Contributor
5 years ago

Hi xiumi_hou ,

Try with this code..

 

Activation before =
CALCULATE (
    DISTINCTCOUNT ( d_Cases[Id] ),
    d_Cases[Activation_date_c] <= MIN ( d_date[Column_date] ),
    CROSSFILTER ( 'case table'[assigned date], d_date[Date], NONE ),
    USERELATIONSHIP ( d_Cases[Activation_date_c], d_date[Date] )
)