Forum Discussion

matt_campbell's avatar
matt_campbell
Regular Visitor
1 year ago
Solved

Measures with Sum in Matrix Rows

Hi all - I have a Matrix visual showing inventory liquidation data. The rows come from a pre-aggregated fact table. Filtering works fine for 1:1 relationships (stocked month to inventory), but break...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi matt_campbell ,

    Please find attached snap and PBIX file.

    If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

     

matt_campbell's avatar
matt_campbell
Regular Visitor
1 year ago

This does not accomplish setting multiple rows. I need each row to be Stocked Month, Stocked Inventory, Inventory Remaining. The columns should be Sold Month. Values are Count of Sold. I've attached an updated example. 

 

v-dineshya's avatar
v-dineshya
Community Support
1 year ago

Hi matt_campbell ,

Please find attached snap and PBIX file.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

 

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi matt_campbell ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

     

    Thank you.