Calculating Ratio with DAX

[Anonymous]

I'm trying to calculate Dispute ratio (measure) using dax but I'm missing quite a few things in my DAX formula. 

Hope the screenshot below helps:

The first row is being calculted correctly,however, others are not. I would like to show 0% in Dispute ratio for the second row. 

What am I am missing in my DAX formula?

[amitchandak · Accepted solution]

Both Count Distinct and Count in the case of Transaction and Dispute will show as count on the visual value list(display name in values - right side ). Can you right-click on those and check they are count distinct only.

[Anonymous]

Thanks amitchandak.

It worked. Now, the calculations are correct except the ones where there should be 0 in "Count of Diputes" column. Example is in the second row in the screenshot I share. The "1" basically represents all blank values. The Dispute Rate for that second row must be 0% though.

[amitchandak]

Can you first calculate a column or use this in your calculation

IF(value=0, blank(),value)

This will not count 0 value.