Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
ithomason
Regular Visitor

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

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:
ithomason_0-1675867968279.png

 

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

ithomason_1-1675868025891.png

 

 

2 REPLIES 2
ithomason
Regular Visitor

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

GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors