Forum Discussion

knotpc's avatar
knotpc
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Row totals for basic NestIF not totaling as expected.

Hoping the gurus on Power BI can help. Also, open to alternative methods.    I have a measure "Predicted Revenue EoY = IF([Revenue]>[ForecastRevenue],[Revenue],[ForecastRevenue])". The measure is f...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    knotpc there are many blogs and post on this and here is link to one. Hope this helps.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

knotpc there are many blogs and post on this and here is link to one. Hope this helps.

knotpc's avatar
knotpc
Icon for Advocate I rankAdvocate I
6 years ago

Parry2K, 

 

Thank you for the link. It led me down the path to understanding that the measure I wrote was dead wrong for the use case. So back to the drawing board I go. 

 

Clint.