Crtieria Table for Selected Sales

[swwong1]

Hi All

https://www.dropbox.com/s/0sy7atxc8vpfo43/SPECIAL%20CLIENT%20REPORT.pbix?dl=0

I am trying to use a 'criteria' table to calculate the sales for those clients that meet the below criterias (such as type, date period, and country)

I would like to display this information in one table so I can view both total sales and the 'selected sales' at a client level.

Have tried to use USERELATIONSHIP as they are inactive relationships but can't seem to show this properly based on the type and country.

Thanks All!

[amitchandak]

@swwong1 , Create a measure with removefilters or all to remove the filter of type and date

All sales = calculate(Sum(Table[sales]), removefilters(Table[Type], Table[Date]) )

or

All sales = calculate(Sum(Table[sales]), all(Table[Type], Table[Date]) )

Learn Power BI: All, allselected, removefilters,allexcept- https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s