Forum Discussion

dustdaniel's avatar
dustdaniel
Icon for Helper II rankHelper II
2 years ago
Solved

Matrix showing all dates instead just those with values.

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

 

 
Need Help
  • sevenhills's avatar
    sevenhills
    2 years ago

     

    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"))

2 Replies

  • sevenhills's avatar
    sevenhills
    Icon for Super User rankSuper User
    2 years ago

     

    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"))