I have what I hope is a simple use-case, but it’s proving to be difficult.
I would like to do the following:
Measure1 = SUM ( Field 1 * Field 2 * 1e6 )
Please note that fields 1 & 2 are from different tables, and I’m getting an error when trying to run this.
Then , if possible, I want to create a second measure that does this:
Measure 2 = SUM(If Field4 = "Tiger" then Measure1 else 0 end)
Note Measure 1 in this case should be the result of the calculation up above.
It’s funny this feels like this should be quite simple, but I’ve tried several iterations and cannot seem to get a working calculation.
As a final point, my hope is that slicers selected will also impact these calculations based upon different selections of slicers.
If anyone can help I’d be extremely grateful!