PDA

View Full Version : Dynamic DAX measure for value field settings



Arnoux
2015-07-24, 10:55 AM
Good day people. I need a dax measure which will keep the 100% base of the answers in the value field in my pivot tables to whatever is most left in my pivot table. For example.


Value field




x1

50%




x2

50%




x Total

100%




But If I change the pivot table to show me another base item it must change to this automatically


y1

30%




y2

70%




y Total

100%




Thank you
Regards
Arnoux
3750

Herbds7
2015-07-25, 12:52 AM
Excel 2013 Pro Plus
With ALL()
Rob Collie's rules:
Never use implicit Calculated Fields (aka Measures) like Sum of ...
Never use Calculated Columns when Calculated Fields will do.
Read his books.
http://www.mediafire.com/view/wb1q8hsy2xf107f/07_24_15.xlsx

(http://www.mediafire.com/view/wb1q8hsy2xf107f/07_24_15.xlsx)