Forum Discussion
Solved
Create a filter/dimension for measures
Hi, I have a number of measures in my workbook, 10, which are laid out in the order Code, Date, Measure 1, Measure 2, ... Measure 9, Measure 10 where code is the location and date is the date the...
Could this technique work for you? http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Could this technique work for you? http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Hi Matt,
Thanks for this it worked for me. I had to tweak the switch formula thoguh to be sum('Table_name'[measure 1]) as it didn't recognise it with out the calucation and would only use measure I had already calculated. Apart that small tweak it worked perfectly.
Thanks