Forum Discussion

rdurrell's avatar
rdurrell
Frequent Visitor
1 year ago
Solved

Display Different summarizations by level in a matrix visual

I have a data set that has 5 different columns. Year, month, sector, company, and customer count. See below for an example:   Company Year Month Sector Customers ABC Co 2024 1 Personal...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    rdurrell create this measure:

     

    My Measure = 
IF ( ISINSCOPE ( Table[Month] ) || ISINSCOPE ( Table[Sector] ), 
      SUM ( Table[Customers] ),
      AVERAGE ( Table[Customers] )
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
1 year ago

rdurrell create this measure:

 

My Measure = 
IF ( ISINSCOPE ( Table[Month] ) || ISINSCOPE ( Table[Sector] ), 
      SUM ( Table[Customers] ),
      AVERAGE ( Table[Customers] )
)
rdurrell's avatar
rdurrell
Frequent Visitor
1 year ago

I had to change the formula around to take the sum and divide by 12 to get the avg per year, but your code was still very helpful!! THank you