If the result is 0 then count as 1 Problem

[Beginner_2020]

Hi Power BI Community!

I want that the DoA rate is 100 % when DoA Count = 1 and Count of parts = 0

This is my measure. I thought about a IF function but I need this measure to show values with zero on my chart in the right time fraim.
DOA rate (monthly) = var result =(DIVIDE('Parts per Month'[DoAs], [Count of Parts]))+0

return if(result, result, IF(MAX(Dates[Date2])>DATE(2019,9,30),0, BLANK()))

Can I add to this measure another function so that it counts every DoA Count with zero count of parts as 1?

[Greg_Deckler]

@Beginner_2020 - If you have a measure for "DoA Count" and "Count of Parts" and they work, can you just do this:

DoA Rate =
  IF([DoA Count]=1 && [Count of Parts]=0,1,BLANK())

[Beginner_2020]

@Greg_Deckler Thank you for your reply. How can I include a second IF fuction?

DoAs DOA rate (monthly) = var result =(DIVIDE('Parts per Month'[DoAs DOA], [Count of Parts]))+0

return if(result, result, IF(MAX(Dates[Date2])>DATE(2019,9,30),0, BLANK())) -> I need this for the visual

How can I add this without destroying my former measure: 

IF ('Parts per Month'[DoAs DOA]=1 && [Count of Parts]=0,1,BLANK())

[Greg_Deckler · Accepted solution]

@Beginner_2020 - Well, you shouldn't, you should use SWITCH(TRUE()...) but if you must:

IF(

  <condition>,

  IF(

     <other condition>,

     <result true>, 

     <result false>

  ),

  <result first if is false>

)

Or if you mean logic, IF(<condition> && <other condition>,true,false)

[amitchandak]

@Beginner_2020 , Not very clear to me

Assume you have two measures DoA Count  and Count of parts , then you can have a measure

if([DoA Count] = 1 && [Count of parts] = 0,1 ,[DOA rate (monthly)])

You can use one measure inside another one. When want to filter using a measure, you need to take care of row context

[Beginner_2020]

@amitchandak 
Thank you for the reply. I have the two measure DoA Count and Count of parts

DoA Count = var result =

CALCULATE (

COUNT ( 'Stammdaten Komplett'[ID] ),

FILTER ( Dates, MAX ( Dates[Date2] ) > DATE ( 2019, 9, 30 )),

FILTER (

'Stammdaten Komplett',

'Stammdaten Komplett'[PartStatus] = "Dead on arrival (DOA)"

)

)

return if(result, result, IF(MAX(Dates[Date2])>DATE(2019,9,30),0, BLANK()))

Count of Parts = var result = SUM('All Parts'[adjusted quantity])

return if(result, result, IF(MAX(Dates[Date2])>DATE(2019,9,30),0, BLANK()))

Where should I put the new IF measure in both of them? I am sorry - still a beginner...

[amitchandak]

@Beginner_2020 , if is fine but check value or result 

result  >0 

result <> 0

isblank(result ) 

not(isblank(result ))

do not just give results in if unless the true-false value is expected. It might work. But may change result ay someplace