Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter for showing chart null values

Hi Power BI Community!

How can I show the months with zero values - How should I edit my measure/filter?
For example: 
Dezember, Januar ,...

Measure=
DoAs DOA =
CALCULATE (
COUNT ( 'Stammdaten Komplett'[ID] );
FILTER ( Dates; MAX ( Dates[Date2] ) > DATE ( 2019; 9; 30 ));
FILTER (
'Stammdaten Komplett';
'Stammdaten Komplett'[PartStatus] = "Dead on arrival (DOA)"
)
)
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thank you for the quick response - I already tried 0 but it destroyed the time fraim

     



    I did other measure like this 

    = var result = ....
    return if(result; result; IF(MAX(Dates[Date2])>DATE(2019;9;30);0; BLANK())) 

    but now I need to also filter 
    'Stammdaten Komplett'[PartStatus] = "Dead on arrival (DOA)"


2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Try +0 

    Measure=
DoAs DOA =
CALCULATE (
COUNT ( 'Stammdaten Komplett'[ID] );
FILTER ( Dates; MAX ( Dates[Date2] ) > DATE ( 2019; 9; 30 ));
FILTER (
'Stammdaten Komplett';
'Stammdaten Komplett'[PartStatus] = "Dead on arrival (DOA)"
)
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for the quick response - I already tried 0 but it destroyed the time fraim

       



      I did other measure like this 

      = var result = ....
      return if(result; result; IF(MAX(Dates[Date2])>DATE(2019;9;30);0; BLANK())) 

      but now I need to also filter 
      'Stammdaten Komplett'[PartStatus] = "Dead on arrival (DOA)"