Forum Discussion

jhd's avatar
jhd
Helper I
7 years ago
Solved

Using SUM as a FILTER Condition

=CALCULATE( DISTINCTCOUNT(MASTER_DATA[DATE]), ALL(MASTER_DATA[DATE]), MASTER_DATA[UNITS]>0))   My table of data (called MASTER_DATA) DATE UNITS 01/04/2017 -100 01/04/2017 100 05/...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    jhd

     

    Try this revision

     

    Measure =
CALCULATE (
    DISTINCTCOUNT ( MASTER_DATA[DATE] ),
    FILTER (
        ALL ( MASTER_DATA[DATE] ),
        CALCULATE ( SUM ( MASTER_DATA[UNITS] ) ) > 0
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

jhd

 

Try this revision

 

Measure =
CALCULATE (
    DISTINCTCOUNT ( MASTER_DATA[DATE] ),
    FILTER (
        ALL ( MASTER_DATA[DATE] ),
        CALCULATE ( SUM ( MASTER_DATA[UNITS] ) ) > 0
    )
)
  • jhd's avatar
    jhd
    Helper I
    7 years ago

    Thanks Zubair_Muhammad, that worked perfectly!