cancel
Showing results for
Did you mean: Helper IV

## If the result is 0 then count as 1 Problem

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?

1 ACCEPTED SOLUTION Super User IV

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

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

6 REPLIES 6 Super User IV

@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())``````

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User! Helper IV

@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()) Super User IV

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

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User! Super User IV

@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

Proud to be a Super User! Helper IV

@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... Super User IV

@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   