Forum Discussion

pbiuser12345's avatar
pbiuser12345
Helper I
3 years ago
Solved

Zero Values For Measure Not Appearing in Matrix Visual

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 var...
Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    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

     

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

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