Optimizing ratio in Power BI model

[RohanS]

Hello All,

Say for case like Measure c = a/b, is there any way to avoid recalculating a and b again to get value of c. Tabular works that way, hence the confusion. Or already Power BI is doing something smart here?

Please help here.

[v-chuncz-msft · Accepted solution]

@RohanS 

You may take a look at the links below.

• https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
• https://www.sqlbi.com/?s=variables