Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

rows in matrix?

Hi This may be a dumb question, I am new to PBI, but any help would be appreciated.   I have been ask to recreat this report using PBI      01-Jan 01-Feb 01-Mar 01-Apr Grand Total Sum...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Anonymous,

     

    Try these measures:

     

    Sum of Attended = SUM ( Table1[attended] )
    Sum of maxPlaces = SUM ( Table1[maxPlaces] )
    % filled = DIVIDE ( [Sum of Attended], [Sum of maxPlaces] )

     

    Add all three measures to the Values field well of a matrix, and toggle "Switch values to rows" on:

     

     

     

DataInsights's avatar
DataInsights
Super User
4 years ago

Anonymous,

 

Try these measures:

 

Sum of Attended = SUM ( Table1[attended] )
Sum of maxPlaces = SUM ( Table1[maxPlaces] )
% filled = DIVIDE ( [Sum of Attended], [Sum of maxPlaces] )

 

Add all three measures to the Values field well of a matrix, and toggle "Switch values to rows" on: