Forum Discussion

Leo7736's avatar
Leo7736
New Member
2 years ago
Solved

Power bi matrix issue

Hi can someone give some insights about how to achieve this type of matrix in power bi ("Total" row as count of sales, "Total" column as sum of sales).  

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    2 years ago

    Leo7736 write a measure like this:

     

    Measure = 
IF ( HASONEVALUE ( Table[Product] ), SUM ( Table[Sales] ), COUNTROWS ( Table ) )

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Leo7736 write a measure like this:

     

    Measure = 
IF ( HASONEVALUE ( Table[Product] ), SUM ( Table[Sales] ), COUNTROWS ( Table ) )