Measure to Get Distinct count without filters affecting the results

[mohammedismail]

Hi Everyone,

I have a report with Multiple Tables on a page. I want to Count Unique No of Customers for a Particular Supplier. I have other table which has Country and Category Information when ever I choose any country/ Category via the Table or via the Slicer I do not want the Distinct Count values to Change. I tried using DAX CountDistinct and AllExcept and that does not seem to be working as expected.

Any help would be appreciated.

[Anonymous]

Hi @mohammedismail ,

Try disable the interaction between specific slicer and visual.

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

Best Regards,

Jay

[Greg_Deckler]

@mohammedismail Try COUNTROWS(DISTINCT(ALL

[mohammedismail]

This is returning the total Unique Customers for all the Suppliers. The same number repeats in all the rows.