Forum Discussion

xl0911's avatar
xl0911
Helper III
4 years ago

Measure that counts Active subscribers

Hello,   This is a continuation ticket from a previous ticket I opened, following my prompting mistakes, which accumulated a lot of messages that were simply difficult to follow and I was advised t...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

I have contributed to your original thread.  Have you reviewed my solution? 

xl0911's avatar
xl0911
Helper III
4 years ago

Hi Ashish_Mathur,

 

Your solution is this DAX formula:

 DISTINCTCOUNT(Data[Product Id])

 

And it's not what I need as you can see in my question.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    That is not correct.  Please see the transformations (in the Query Editor) that i have applied to your dataset.

    • xl0911's avatar
      xl0911
      Helper III
      4 years ago

      Thank you but I need a DAX solution.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi xl0911 ,

         

        I am sorry for late reply. Could you tell me if your issue has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it.

        Or you are still confused about it, please share your sample file with me agin. It seems that your transfer expired. I do not have access to your sample file. 

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.