How to show only records with data

[alenknight]

I have the following Dataset.  I want to have Power BI show ONLY the Stores that have sales in every Product 

so, in a Matrix - the below would ONLY show Store 1... as it's the only one that shows a sale in all 3 products.

any help would be appreciated.

sample data :

Stores	Product	Sales
Store1	A	3
Store2	B	4
Store3	C	2
Store1	B	1
Store2	B	1
Store3	B	5
Store1	A
Store2	B
Store3	C	4
Store1	C	5
Store2	B	6
Store3	B	2
Store1	A
Store2	C
Store3	B	2

and this is what i'm getting out of a matrix in PBI  desktop :

[alenknight]

excellent! that worked, thanks!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Sales only has ALL Products: =

VAR allproductslist =

ALLNOBLANKROW ( Products[Product] )

VAR currentstore_productlist =

CALCULATETABLE ( VALUES ( Data[Product] ), ALL ( Products[Product] ) )

VAR conditions =

IF ( COUNTROWS ( allproductslist ) = COUNTROWS ( currentstore_productlist ), 1 )

VAR result =

IF ( conditions = 1, SUM ( Data[Sales] ) )

RETURN

result

Total Fix: =

SUMX (

SUMMARIZE ( Data, Stores[Stores], Products[Product] ),

[Sales only has ALL Products:]

)