Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help needed for Measure

Assuming data as follows:   COLA   COLB                COLC AA       04/01/2018          1 AA       04/02/2018          0 AA       04/03/2019          1 BB       04/01/2019           1 BB     ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    Just modify measure as below:

     

    Measure = 
CALCULATE(DISTINCTCOUNT('Table'[COLA]),FILTER(ALLEXCEPT('Table','Table'[COLB]),YEAR(SELECTEDVALUE('Table'[COLB]))=MAXX(ALL('Table'),YEAR('Table'[COLB]))&&'Table'[COLC]=1))+0

     

    And you will see:

     

    I have modified the pbix file,pls click here.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry,  The total should be 19.    9 count on 3/6/19 and 10 count on 3/7/19.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-kelly-msft . Please ignore my previous comment.  The caffien had not kicked in when I posted it.  The correct values are as stated previously.