Forum Discussion

Graitec's avatar
Graitec
Regular Visitor
6 years ago
Solved

Visual filter from a DAX Sumx filter expression

Hi,   I want to query the number of licences which are active for each week so I can show the increase in licences over time.  I have created two date tables as below which work, I suspect there is...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Graitec ,

     

    Would you please refer to the measure below:

    Number of Active Licences = Sumx(filter(Purchases,Purchases[License Expiry Date]<MAX('Dates - Week/Year'[WeekStartDate])),Purchases[Quantity])

     

    Best Regards,

    Dedmon Dai

Graitec's avatar
Graitec
Regular Visitor
6 years ago

Thank you for replying. 

 

Yes Business Unit is a related table however the count DAX isn't a measure, it's a column because I want to reply on the count for each week in the past. From what I understand a slicer won't work on a column like this as I need to include the filter in the DAX. 

parry2k's avatar
parry2k
Super User
6 years ago

Graitec question comes down to , why you are it is as a calculated column, why not a measure which is usually the best approach?