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
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.

      • xl0911's avatar
        xl0911
        Helper III
        3 years ago

        Hello,

         

        I solved it by the SQL Server data source level.