Forum Discussion
omerpq
8 years agoRegular Visitor
Replacing Values in the Visual (Calculated) Column
Dear All: All the best in all the reporting. I am too new to Power BI but the current stage where I am stuck has made me Go Through Power BI a lot. A blessing in disguise. :) I need to Replace the ...
- 8 years ago
=IF([Measure1]=blank(),[Measure2],[Measure3])
or some variation. You can use nested IF if needed, or even SWITCH TRUE
https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
- 8 years ago
I mean you should write a measure that reacts to the circumstances that are presented in the visual.
MattAllington
8 years agoCommunity Champion
I mean you should write a measure that reacts to the circumstances that are presented in the visual.
omerpq
8 years agoRegular Visitor
Perfect solution you have quoted Matt... very nice. My issue resolved as well.
I have had been stuck since days over it.. Good Luck.
Thanks,