Forum Discussion
Creating a Measure with dynamic computation depending on another column's value
I am trying to create a matrix in the following format, where the values is just 1 measure (computed from Volume column). Expected result: Sample data: This is the code I came up wi...
Anonymous , Try like
calculate(
DIVIDE(
_variance,
_begINV + _volRCV
), REMOVEFILTERS('Terminal In-Plant Performance'[Attribute]))
For formattin refer dynamic string formatting
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/
I tried this. Unfortunately, it didn't work. the whole Variance % column did not show up. the rest of the columns worked perfectly fine.