Forum Discussion

Yarters's avatar
Yarters
Frequent Visitor
3 years ago
Solved

Perfect Days Flag

Hi    I'm new to DAX and have followed a number of guides which have got me started but I'm struggling to get something to work and would appreciate some help please!   I have an 'Event' table an...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Num perfect days =
VAR SummaryTable =
    ADDCOLUMNS ( VALUES ( 'Calendar'[Date] ), "@num days", [No. of events] )
VAR Result =
    COUNTROWS ( FILTER ( SummaryTable, [@num days] = 0 ) )
RETURN
    Result
Yarters's avatar
Yarters
Frequent Visitor
3 years ago

Thanks, that gives me a count - and if I create another measure like this I can stack the 2 measures in a stacked bar - thanks for your help!

Num Imperfect Days =
COUNTROWS('Calendar') - [Num perfect days]