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. 

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

[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