How to show 0 instead of blanks

[RogerSteinberg]

I would like to calculate various ratios per day.

For example, I have a column with possibility of values A, B for each day.

I would like to calculate the ratio of A to totals.

Certain days I can have no values of A.

When I use the following measure, I will have blanks instead of zeros.

DIVIDE(

CALCULATE(

COUNT('Model'[ID]),

'Model'[Event] = "A"

),

CALCULATE(

COUNT('Model'[ID])

)

)

As you can see in the Image, I should expect 50%, 0 %, 0% ,0 %, 0% . How can I achieve this ?

[Tahreem24]

Just tweak your measure like below:

DIVIDE(

CALCULATE(

COUNT('Model'[ID]),

'Model'[Event] = "A"

),

CALCULATE(

COUNT('Model'[ID])

)

) +0

[aj1973]

@RogerSteinberg 

Add 0 there

DIVIDE(

CALCULATE(

COUNT('Model'[ID]),

'Model'[Event] = "A"

),

CALCULATE(

COUNT('Model'[ID])

), 0

)

[RogerSteinberg]

Tried that but still have blanks on days without any EVent of type "A"

[aj1973]

@RogerSteinberg 

Use IF(ISBLANK(Your Measure), "0", Your measure)

[aj1973]

@RogerSteinberg 

Use IF(ISBLANK(Your Measure), "0", Your measure)

[RogerSteinberg]

the ISBLANK() function requires a parameter though. but if i put my measure inthere, i have the same issue with the proposed solution from mahoney below, i get dates from my date table where theres no data at all

[PhilipTreacy]

Hi @RogerSteinberg 

Try this

Column = 

VAR _res = DIVIDE( CALCULATE( COUNT('Model'[ID]), 'Model'[Event] = "A"), CALCULATE( COUNT('Model'[ID]) ) ) 

RETURN

IF ( ISBLANK(_res), 0, _res)

Regards

Phil

[aj1973]

@RogerSteinberg 

Please share a sample Pbix, It would be easier for us all to help you.

[mahoneypat]

Just add +0 to the end of your expression.

Pat

[RogerSteinberg]

it adds also all the dates from my model where no data is generated. which is not what I want.  this happens when i have a 1to many relationswhip with my date table and use the date column from the date table.

[mahoneypat · Accepted solution]

Figured that would happen.  Try this instead.

NewMeasure = var vResult = [YourExpression]

Return IF(AND(NOT(ISBLANK([Count])), ISBLANK(vResult)), 0, vResult)

Pat