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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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