Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.