Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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)] )))
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |