ALLNOBLANKROW summary confusion? help understanding

[alenknight]

I got some help recently with a dataset, to remove blank records - using ALLNOBLANKROW from this :

Solved: Re: How to show only records with data - Microsoft Power BI Community

This worked... however, when i expand the dataset, essentially when every Store (column) has a value, the result is just a summary, and not showing every store.  i tried changing the parameters around, but i can't seem to figure it out.  I want the script to show every store and their respective calculations... except the ones  that have blank records.  (ie  don't summarize and remove the stores).  if they all have data, then show them all... or show only the ones that have data in every record.

here's my dataset :

Stores	Product	Sales
Store1	A	15.39
Store2	B	314.99
Store1	C	15.95
Store2	B	16
Store3	C	319.99
Store2	B	439.99
Store2	A	16.5
Store1	B	16.5
Store3	C	165
Store2	C	165
Store1	B	16.69
Store2	A	16.99
Store2	B	16.99
Store1	A	17.09
Store2	C	17.5
Store3	C	17.5
Store1	A	87.69
Store2	B	354.49
Store1	B	17.99
Store1	A	17.99
Store2	C	17.99
Store1	B	17.99
Store2	A	18
Store1	B	359.8
Store2	B	359.8
Store1	A	359.99
Store2	B	365
Store2	D	369
Store1	A	18.49
Store2	D	18.49
Store1	C	18.5
Store3	D	36.99
Store3	D	369.69
Store3	D	369.99
Store3	B	369.99
Store2	B	369.99
Store3	A	499.5
Store3	D	18.75

Here's my measure (from the prior solution) :

Sales only has ALL Products: =

VAR allproductslist =

ALLNOBLANKROW ( Sheet1[product] )

VAR currentstore_productlist =

CALCULATETABLE ( VALUES ( Sheet1[product] ), ALL ( Sheet1[product] ) )

VAR conditions =

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

VAR result =

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

RETURN

result

and here's what it's looking like (i should see stores in columns, but instead it's summarizing them all)

[alenknight]

i'm not sure how you are getting that.... i have [STORES] column in the rows field... still showing same...

[v-jayw-msft]

Hi @alenknight ,

Please check the PBIX file that I create according to the sample data you shared. I just use the data and formula and did not make any change.

Best Regards,

Jay

[v-jayw-msft · Accepted solution]

Hi @alenknight ,

You missed the [Stores] column in Rows field.

Best Regards,

Jay