How do I get rid of the "Infinity" from my DAX?

[Anonymous]

Hi All,

I have the below DAX that works for the dates selected but on either side of the range selected I get "infinity" entries on my row.

Please see below - Is there something I need to omit from the below to avoid this?

var Priorweeks = if(MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Quarter]) >= 0 && max('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Quarter]) = 0,

calculate(max('Plan PBI_GTS_SIOP_Supply_Demand'[Forecast (RXN)])-

sum('Plan PBI_GTS_SIOP_Supply_Demand'[PriorWeekSum]), REMOVEFILTERS('Plan PBI_GTS_SIOP_Supply_Demand'[Fiscal Year Week Number])), blank())

return

IF (MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Quarter])>0, SUM('Plan PBI_GTS_SIOP_Supply_Demand'[Dynamic Demand Column]),

IF(MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week])<0, SUM ('Plan PBI_GTS_SIOP_Supply_Demand'[Actual Shipments Forecasted Demand]),

IF(MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Quarter])=0 && MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week])>=0,

Priorweeks/max('Plan PBI_GTS_SIOP_Supply_Demand'[PBI Fiscal_Calendar - Week Level.Remaining Weeks])

)))

Thanks Folks 

[ValtteriN · Accepted solution]

Hi,

Instead of using / for division use DIVIDE here:

DIVDE(Priorweeks,max('Plan PBI_GTS_SIOP_Supply_Demand'[PBI Fiscal_Calendar - Week Level.Remaining Weeks]))

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

@ValtteriN Hero, thank you so much for this. It has been driving me mad for a while now.