Missing Data

[JamesBurke]

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 the below measures to track the Meters health

Max Date new = 
    CALCULATE(
        Max('National Grid Data'[Date]),
        FILTER('Date',[Total solar Generated] >= 0),
        ALL('Date'))
        

Min Date new = 
    CALCULATE(
        MIN('National Grid Data'[Date]),
        FILTER('Date',[Total solar Generated] >= 0),
        ALL('Date'))
        

Working Days in This Period = CALCULATE(DATEDIFF([Min Date new],[Max Date new],DAY),All('Time'[Day/Night ]))

This Will keep a record of the amount of days of data i currenlty have

Working Days in This Period 2 = CALCULATE(DATEDIFF([Min Date new],[Today Date],DAY),All('Time'[Day/Night ]))

This will keep a record of how many days they should have as it's from the start date to today. 

Days Missed = [Working Days in This Period 2] - [Working Days in This Period]

Connected = IF([Days Missed] >= 1 , "Not Connected",  "Connected")

However when i put this Measure into a pie chart the visual is blank and doesn't show any data. But as you can see in the image below in a chart it shows them not connected. 

Any Help would be appericated 🙂

[Anonymous]

Hi @JamesBurke ,

May I kindly ask if your issue has been resolved? If there is an answer that helped you, please accept it as a solution. This will be of great help to other users who have similar problems as you.

If not, please do not hesitate to let us know, and we will be more than happy to assist you further.

Best Regards,

Bof

[Bibiano_Geraldo]

Hi @JamesBurke ,

Please note that in pie chart value field, only support scalar values and Matrix accept all types of values. The blank result you’re seeing is likely because your measure is returning a string. To test this theory, try returning 0 instead of "Not Connected" and 1 instead of "Connected."

If this doesn’t resolve the issue, feel free to share additional details or screenshots of your setup. This will allow us to provide more targeted assistance.

If this helps, please accept it as the solution and give a kudos.

Thank you!

[Kedar_Pande]

@JamesBurke 

create a calculated column:

Meter Connection Status = 
IF(
[Days Missed] >= 1, 
"Not Connected", 
"Connected"
)

Legend: Meter Name (groups) (Ensure this is a categorical field)

Value: A calculated column (Meter Connection Status)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[rajendraongole1]

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