count and avoid filter context

[anusha_2023]

Measure To Count Opportunity Line ID per Product =

CALCULATE(

    COUNT(OpportunityLine[Id]),

    ALL('CurrencyConversion'[IsoCode])

)

I have a slicer with ISOCode from CurrencyConversion table. While I am showing a matrix with count of opportunityline Id’s for product names want to avoid filter context from CurrencyConversion because of that user ALL function in the above measure which is giving correct count but still filtering the product names which are belonged to selected currencyCode. I want to show all product names and count of opportunitylines regardless what value chosen from filer ISOcode which is from CurrencyConversion table. Here I have slicers from other tables so do not want to remove all fiters while applying above measure. Please suggest me further if you have any views.

[lbendlin]

Sounds good.  What is your question?  Does it not work?

[anusha_2023 · Accepted solution]

Thanks for the reply. Re creating the visual worked