Forum Discussion
Solved
Conditional calculation in Matrix visual using Excel's SUMPROD function
Hello PBI Community, Greg_Deckler I'm an intermediate level user struggling to do some hocus pocus with a Matrix visual. When Class column is expanded, Average column does an average (i.e., 5, ...
BlackDevX , Create a new measure
divide(Sumx(Table, Table[Days]*[Average]), sum(Table[Days]) )
BlackDevX , Create a new measure
divide(Sumx(Table, Table[Days]*[Average]), sum(Table[Days]) )