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 for the reply. It still shows blank. I want to calculate how many was active before or on the April 1st

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, xiumi_hou 

 

Oh... before or on the 1st day of the selected month??

Or is it before the 1st day?

I hope you can change as you wish.

please include ALLSELECTED function inside the measure.

 

Activation before =
CALCULATE (
    DISTINCTCOUNT ( f_calls[Parent_id] ),
    FILTER (
        ALLSELECTED ( f_calls ),
        f_calls[f_Cases.Activation_date_c] <= MIN ( d_date[Date] )
    ),
    USERELATIONSHIP ( f_calls[f_Cases.Activation_date_c], d_date[Date] )
)

 

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 for the reply. This still show results blank. Can you please help me take a look at the below query?

    Activation before = CALCULATE(COUNT(d_Cases[Id]),filter(ALLSELECTED(d_Cases),
    d_Cases[Activation_date_c]<=min(d_date[Column_date])
     
    ),USERELATIONSHIP(d_Cases[Activation_date_c],d_date[Date]))
    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi,

      I am not sure, but perhaps, it has something to do with the context.

      Please let me have a look at your sample pbix file. Then I can try to create more accurate measures.

       

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