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.
But If I change the pivot table to show me another base item it must change to this automatically
Thank you
Regards
Arnoux
View attachment Excel Guru MAster Perc Upload.xlsx
| Value field | ||
| x1 | 50% | |
| x2 | 50% | |
| x Total | 100% |
| y1 | 30% | |
| y2 | 70% | |
| y Total | 100% |
Regards
Arnoux
View attachment Excel Guru MAster Perc Upload.xlsx