Matrix Table

[SteffanieJ]

Hello All!

I have a Matrix with columns for sales, cancelled value, and fill rate % and rows with weeks, cancelled reason, category, and product.  I need to be able to use a cancelled reason slicer and have the value change on the cancelled value column but the sales column needs to stay the same and the % needs to be able to update as well.  

Is this possible and how would I handle this?

This is the measure I used for the net value.

Here are the totals without any filters on.

If I use the slicer and select Product Availability Issue it kicks out the net value of the blanks.

So basically I need the Total to stay at the $19,370,685, the cancelled value update to only those cancelled for product availability.

[adudani · Accepted solution]

Hello @SteffanieJ ,

Kindly provide the sample input/output in a usable format (excel, csv, table etc.) masking sensitive information.

reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447... 

Thanks,

[v-aatheeque]

Hi @SteffanieJ ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @SteffanieJ ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @SteffanieJ ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!