Forum Discussion

Charu's avatar
Charu
Icon for Post Patron rankPost Patron
8 years ago

How to use both Avg and sum function in DAX

Hi Everyone,   I have 4columns like below Col1 : Col2 : Col3 : Col4 0         0       1         0 I want to first sum these 4 columns and then need to get Average. Please help me how to create ...
Need Help
jcarville's avatar
jcarville
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

You can unpivot the 4 columns to create 1 column. Then use this new column and change the type to sum or average using the drop down arrow under the values section of the visualisations pane.