Forum Discussion

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost 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
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, xiumi_hou 

Thank you for your message.

In this case, I think the approach has to be made in a little bit different way.

I can write based on this case only. My measure might not be appropriate if there are any other related tables to this case.

 

- do not activate any relationships between date-table and case-table. All relationships have to be inactive.

 

Please check the below if I correctly understand your request, and please let me know.

 

Active Clients Count =

COUNTROWS(CALCULATETABLE('Cases', FILTER( 'Cases',
'Cases'[Activation Date] <= MAX(dates[Date]) && 'Cases'[Closed Date] >= MIN( dates[Date]) && 'Cases'[Activation Date] <> BLANK())))
+
COUNTROWS( CALCULATETABLE('Cases', FILTER( 'Cases',
'Cases'[Activation Date] <= MAX(dates[Date] )&& 'Cases'[Closed Date] =BLANK() && 'Cases'[Activation Date] <> BLANK())))


 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

 

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost 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?