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 ( '...
  • 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)"


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