Matrix showing all dates instead just those with values.

[dustdaniel]

Hi there,

I've been using PBI for the last 2 month and this community is awsome, this is my first post so I'll do my best for you to understand.

I want to show in a matrix the average handle time per agent / per date. How do I keep only the dates with values?

I'm sure the issue is the measure because if I remove it from the matrix then it's ok.

 

This is what I have for the measure and I have a table date from 1 to many in the fact table.

Avg Open Time = 
FORMAT(AVERAGE(Contrato[TimeOpenN]), "HH:MM:SS")

Thanks in advance

[dustdaniel]

Thank you!

[sevenhills · Accepted solution]

try like this and see if it works:

Avg Open Time = 
var _a = AVERAGE(Contrato[TimeOpenN])

RETURN IF( NOT(ISBLANK(_a)), FORMAT(_a, "HH:MM:SS"))