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.