Filter not working with cumulative measure

[KatkaS]

Hello,

I created a measure for cumulative number of licences (Please see below).

It is working fine, but not when I apply separate filer on CoE and Operational company...

I do have a relationship created (and working) between a master table that contains list of COEs and companies and the table with list of licences..

I know it is difficult to say, but perhaps there is a simple explanation to it..?

Thank you very much!

# Cumulative total licences = CALCULATE ( DISTINCTCOUNT( 'LD_LinkedIn learning'[GUID]),FILTER (ALL ( 'LD_LinkedIn learning' ), 'LD_LinkedIn learning'[Activation Date (PST/PDT)] <= MAX ( 'LD_LinkedIn learning'[Activation Date (PST/PDT)] )))

[KatkaS]

Thank you!!!

[amitchandak · Accepted solution]

@KatkaS , Try allselected in place of all and check

# Cumulative total licences = CALCULATE ( DISTINCTCOUNT( 'LD_LinkedIn learning'[GUID]),FILTER (allselected( 'LD_LinkedIn learning' ), 'LD_LinkedIn learning'[Activation Date (PST/PDT)] <= MAX ( 'LD_LinkedIn learning'[Activation Date (PST/PDT)] )))