distinct count by category and subcategory

[Anonymous]

hello there is the structure of my table and i would like to calculate and filter a matrice by :

Number distinct  of Sub category by Réception, and Filter reception where saleamount >15.

Thanks !

[Anonymous]

add reception a in table visual.

create measure for distinct count of sub categoeries.

Total Sub=DistinctCount(table [sub categoeries]).

and add this measure to table and visual level filter and set to "is greater than  15"

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.