Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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)] )))
Thank you!!!
@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)] )))