cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Handling infinity value

Hello,

 

I am currently using a measure to calculate Sales Rate. The calculation is as follows FactTable[X]/FactTable[Y]. The X and Y come from different Fact tables. If Y is not present for the corresponding date, I am getting a value of infinity. It would be good to have nothing show up then to have infinity value. How do I achieve this?

 

Thanks in advance

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,

 

Thanks for the reply.

 

I got a solution online before I came across your post. Refer below for the solution.

IFERROR(
    [Mesaure 1]/[Mesaure 2],
    BLANK()
    )

 where Mesaure 1 is Sum(FactTable[x])and Mesaure 2 is Sum(FactTable[y])

 Found it in this blog- https://sqldusty.com/

View solution in original post

4 REPLIES 4
EV
Helper II
Helper II

Found this alternative without getting 'Cannot load Visual Error', DIVIDE function

 

DIVIDE(numerator,denominator,0)

 

Reference: https://www.dutchdatadude.com/power-bi-pro-tip-divide-function/ 

hugoberry
Responsive Resident
Responsive Resident

If FactTable[Y] is zero just display blank for example:

Measure = IF(FactTable[Y]=0,BLANK(),FactTable[X]/FactTable[Y])

Anonymous
Not applicable

Hi,

 

Thanks for the reply.

 

I got a solution online before I came across your post. Refer below for the solution.

IFERROR(
    [Mesaure 1]/[Mesaure 2],
    BLANK()
    )

 where Mesaure 1 is Sum(FactTable[x])and Mesaure 2 is Sum(FactTable[y])

 Found it in this blog- https://sqldusty.com/

View solution in original post

IF Error calculation does work, however it takes a load on the memory and fails with 'cannot load visual' error. Is there an alternative to avoid this issue?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.