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, I have described it as below as attahced a sample dataset, can you please help me and take a look?

Jihwan_Kim's avatar
Jihwan_Kim
Super 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
    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] )
)

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, xiumi_hou 

    Oh, in that case,

    allselected or all function can help to remove filters in only that particular DAX measure.