display all Dimension items in Matrix

[Anonymous]

Hi everybody, 

I am currently facing issue to show all Items(Items is my dimension) in  matrix visual. 

I have one table generated by APPENDING five excel files in power BI, three excel files having country column and other two are not. I have one slicer called Country. 

Below is table when i filter on a country:

see the matrix below without filtering on Country... i want the Items to ignor the country slicer... I want to have below table when filter on Country.

I have tried REMOVEFILTERS(), ALL(), ALLSELECTED() in Measure but did not get desired output.

Best Regards and Thanks for your help...!

Khan

[Anonymous]

Thank You All for helping.

I have solved it By creating new table as suggested by @amitchandak 

[Tahreem24]

@Anonymous, if you want to ignore Country slicer so try "Edit Interaction" feature.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[Ashish_Mathur]

Hi,

Try this measure

=coalesce(average(consolidated[avg_spend]),0)

Hope this helps.

[v-xiaotang]

Hi @Anonymous 

try this,

1. create an independent table Country

Country = SUMMARIZE(Consolidated,Consolidated[Source Country])

2. put Country[Source Country] into slicer instead of Consolidated[Source Country]

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , I such case it is better to have independent date table, because they way filter behaves in power bi

refer

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE