Forum Discussion
Solved
Adding a value to DAX formula breaks my filter context
I have an absolutely maddening powerbi issue which I am having trouble resolving I have a measure called CB COST PLUS PCT which is trying to calculate the percentage we marked up "CB" expenses. A...
Have you tried something like:
IF( OR( ISBLANK( [CB REVENUE] ) , ISBLANK( [CB EXPENSE] ) ) , BLANK() , [CB REVENUE] / [CB EXPENSE] - 1 )
CoreyP
Solution Sage
Solution SageHave you tried something like:
IF( OR( ISBLANK( [CB REVENUE] ) , ISBLANK( [CB EXPENSE] ) ) , BLANK() , [CB REVENUE] / [CB EXPENSE] - 1 )