Forum Discussion
Missing Data
Hi All , I have Two tables One is a date table with records to todays date which updates every day. I also havce a data table which has 5 Meters that measure solar production. I have made t...
Hi JamesBurke - The issue with your Power BI pie chart might be due to the way DAX measures are interacting with the visual filters, particularly around IF conditions and the ALL function.
your connected measure might be returning blank for some groups if the context isn't correctly set.
can you try below measure:
Connected Status =
IF(
ISBLANK([Working Days in This Period]) || ISBLANK([Working Days in This Period 2]),
BLANK(),
IF([Days Missed] >= 1, "Not Connected", "Connected")
)
You are using Meter Name (or similar) as the legend in the pie chart, allowing it to group by each meter.
The Connected status is added in the "Values" field of the pie chart.
the above version checks for blank values in the period calculations