Power bi dashboard

Since your measure already works in a table, you’re almost there. To get it working in a pie chart, you just need to reshape the logic a bit so that the chart can group by "On Time" vs "Not On Time" status.

Here’s a clean way to do it:

1. Create a new measure that returns status per house:

HouseStatus =
VAR AllPartsOnTime =
    CALCULATE(
        COUNTROWS(HouseParts),
        HouseParts[PlannedDate] <> HouseParts[RealDate]
    ) = 0
RETURN
    IF(AllPartsOnTime, "On Time", "Not On Time")

2. Create a summary table (optional but helps):

HouseSummary =
SUMMARIZE(
    HouseParts,
    HouseParts[House],
    "Status", [HouseStatus]
)

3. Use this in your pie chart:

• Legend: Status
• Values: DISTINCTCOUNT(HouseParts[House]) or just House if you're using the summary table

This will give you a pie chart showing how many houses are fully on time vs not, based on your current date filter.

Also make sure your date slicer is filtering the data correctly so the measure reflects the right time window.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI