Zero Values For Measure Not Appearing in Matrix Visual

pbiuser12345 — Mon, 10 Apr 2023 19:18:30 GMT

Hello,

I have a data set I am trying to summarize using a measure in a matrix visual. The data is looking at whether certain trains running on time or not, with the data set being records of various trips. Summarizing the count of trips looks like this:

	On Time	Late
Train A	90	10
Train B	75
Train C	50	50

When I then make use of my measure to summarize the percentage trips that are late, I get this:

Train A	10%
Train C	50%

What I really want though is for there to also be a 'Train B' row with 0% in there. I assume it's because there are no trips that were late and so I'm getting a blank, but various efforts to make it appear (checking for a blank value, adding a 0 to the measure) aren't doing much for me. The DAX looks like this:

% Trips Late = CALCULATE( DISTINCTCOUNT('TRAIN_TRIPS'[TRIP_ID]), 'TRAIN_TRIPS'[LATE_FLAG] = "Late" ) / CALCULATE( DISTINCTCOUNT('TRAIN_TRIPS'[TRIP_ID]), 'TRAIN_TRIPS'[LATE_FLAG] IN {"Late", "On Time"} )

What do I need to do differently to get the table I need?

Thanks for your help!

Re: Zero Values For Measure Not Appearing in Matrix Visual

MohammadLoran25 — Mon, 10 Apr 2023 19:48:32 GMT

Hi pbiuser12345 ,

This Solves your problem (need to use DIVIDE function):

% Trips Late = DIVIDE ( CALCULATE ( DISTINCTCOUNT ( 'TRAIN_TRIPS'[TRIP_ID] ), 'TRAIN_TRIPS'[LATE_FLAG] = "Late" ), CALCULATE ( DISTINCTCOUNT ( 'TRAIN_TRIPS'[TRIP_ID] ), 'TRAIN_TRIPS'[LATE_FLAG] IN { "Late", "On Time" } ) ) + 0

If this solves your question, Please give it a thumbs up and accept it as a solution to make it easier for the others to find what they are looking for.

Regards,
Loran

topic Zero Values For Measure Not Appearing in Matrix Visual in DAX Commands and Tips

Zero Values For Measure Not Appearing in Matrix Visual

Re: Zero Values For Measure Not Appearing in Matrix Visual