Forum Discussion
Need help with Matrix Visual
Jos13 , Create two measure A and B and use
A= countx(filter(Table, Table[status] ="A"),[status])
B= countx(filter(Table, Table[status] ="B"),[status])
for other
offline =countx(filter(Table, Table[offline] ="Yes"),[offline])
do for online an all
Can we skip creating measures for the column Status ?. This column might get new values in the future and I want to show them dynamically in the visual. I tried adding the Status column to the Columns area. But it is not giving the result as expected.
Jos13 , I suggested all measures
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
