Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello ,
I want to visulaize data in matrix.
the rows of matrix are respectely: Provice, City.
the column is months which are 2 months
the value of the matrix is the below measure:
Solved! Go to Solution.
Another possible solution could be to use the ALLEXCEPT function instead of the ALL function. The ALLEXCEPT function removes all filters from a table except for filters on specified columns. You can try using this function to remove all filters from your sale table except for filters on the Province and City columns.
Here’s an example of how you could use the ALLEXCEPT function in your measure:
CALCULATE(
SUM('sale'[quantity]),
ALLEXCEPT('sale', 'sale'[Province], 'sale'[City])
)
I hope this helps! Let me know if you have any further questions. 😊
Another possible solution could be to use the ALLEXCEPT function instead of the ALL function. The ALLEXCEPT function removes all filters from a table except for filters on specified columns. You can try using this function to remove all filters from your sale table except for filters on the Province and City columns.
Here’s an example of how you could use the ALLEXCEPT function in your measure:
CALCULATE(
SUM('sale'[quantity]),
ALLEXCEPT('sale', 'sale'[Province], 'sale'[City])
)
I hope this helps! Let me know if you have any further questions. 😊
Hi razieh12,
It seems that you are trying to use the ALL function to remove the filter context from the months column in your sale table. However, when you drill down to the second level of your matrix, the ALL function is not working as expected.
One possible reason for this issue could be that there are other filters or slicers affecting the data in your matrix. You may want to check if there are any other filters or slicers applied to your data that could be affecting the results of your measure.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |