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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors