Forum Discussion

jakubk1's avatar
jakubk1
Regular Visitor
4 years ago

create filter flag based on filtered subtotal

Hi all,   The 1-2 year gap between working with dax as my role focus changes seems to wipe my brain every time   I'm struggling to remember how to do a filtered subtotal that I can then use to fi...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi jakubk1 
Please try

ValidActivityCount =
CALCULATE (
    DISTINCTCOUNT ( 'DataMart FactActivitySnapshot'[ActivityID] ),
    FILTER (
        CALCULATETABLE (
            'DataMart FactActivitySnapshot',
            ALLEXCEPT (
                'DataMart FactActivitySnapshot',
                'DataMart FactActivitySnapshot'[ContactEmail]
            )
        ),
        'DataMart FactActivitySnapshot'[ActivityCreated] >= [filterdate]
    )
)
  • jakubk1's avatar
    jakubk1
    Regular Visitor
    4 years ago

    Hi, what should happen with that new measure?

    It's still smearing the data across all the rows

     

    (it's the _new in the screenshot)

     

    I tried replacing my valid activity count with the new version in the downstream calcs but it didn't make them any faster