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
johnt75's avatar
johnt75
Icon for Super User rankSuper User
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