count and avoid filter context

anusha_2023 — Thu, 07 Mar 2024 16:06:39 GMT

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.

Re: count and avoid filter context

lbendlin — Thu, 07 Mar 2024 23:06:27 GMT

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

Re: count and avoid filter context

anusha_2023 — Fri, 08 Mar 2024 03:25:26 GMT

Thanks for the reply. Re creating the visual worked

topic count and avoid filter context in Developer

count and avoid filter context

Re: count and avoid filter context

Re: count and avoid filter context