Pie chart from Measure

Sounds like your measure logic is already solid, so the next step is shaping it for a pie chart. Here's how you can approach it:

1. Create a new measure that returns a label like "On Time" or "Not On Time" per house. Something like:

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

1. Build a summary table using SUMMARIZE or a calculated table if needed:

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

1. Use that status in your pie chart:
   • Axis: Status
   • Values: Count of House or DISTINCTCOUNT(HouseParts[House])

This way, your pie chart will show how many houses are fully on time vs not, based on the selected date range.

Also, make sure your slicer is filtering the date range correctly so the measure reflects the right context.

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