Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 =
- Tier 1 Entered Count =
Example data in Power BI Service after I've published and then refreshed online:
I'm not sure how you would do that, as the evaluation is per date?
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?