DAX Columns don't work once published to Power BI Service

[ithomason]

I have a pbix working in Power BI Desktop, with 2 DAX columns that do a count of specific data from other tables for specific dates. These work in the desktop version, and show data once uploaded to Power BI service. 

However, as soon as I refresh the data in Power BI Service these columns clear out. 

Table - 'Ticket Open EOD'

Columns:

- Date

(List of dates)

- Tier 1 Open EOD =

COUNTROWS(

    FILTER(ALL('Ticket Detail'),'Tickets Open EOD'[Date] >= 'Ticket Detail'[Date Created] && 'Tickets Open EOD'[Date] < 'Ticket Detail'[Date Closed] && 'Ticket Detail'[Board ID] = 81 && 'Ticket Detail'[Is Child Ticket?] = "false" && 'Ticket Detail'[Status] <> "Closed - Merged"))

- Tier 1 Entered Count =

COUNTROWS(

    FILTER(ALL('Ticket Detail'),'Tickets Open EOD'[Date] = 'Ticket Detail'[Date Created] && 'Ticket Detail'[Board ID] = 81 && 'Ticket Detail'[Is Child Ticket?] = "false" && 'Ticket Detail'[Status] <> "Closed - Merged"

))

Example data in Desktop:

Example data in Power BI Service after I've published and then refreshed online:

[ithomason]

I'm not sure how you would do that, as the evaluation is per date?

[GilbertQ]

Hi @ithomason 

Why dont you just put all that logic into Power Query so that if the values are true to then put it into the column with a 1 or 0. And then in your data model, you create a measure which will just SUM this column?