error using divide function

[Anonymous]

Hi colleagues,

I have a filter called "site name".

When I use the dax calculation bellow using alternateresult = 1  powerbi ignore the "site name filter". What a mass. I don't know how to solve it.

[Anonymous]

i have a problem in one measure  when using the divide function ... during the calculation the numerator sometimes is resulting blank.

I tryed to use all the methods bellow but they are all making one chart appearing information in the chart that doesn't bellongs to the selectd filter. how to deal with that?

Divide handles division by zero error by returning alternate result. However if the numerator is blank then it returns blank.

There are 3 ways to solve this:

1. COALESCE(DIVIDE(n,d),0)

2. Use IF to check whether ISBLANK(n) then return 0 otherwise perform the division.

3. Use +0 - example: DIVIDE(n+0,d)

Which of the above is the most performant and clean approach?

[ChielFaber]

It looks like the DAX calculation itself is missing from your post. Could you provide it for?