Summing the Distinct Count in a matrix

[kevin757]

I have data with all products which is showing the average list price and the average price that it was actually sold at. 

My current Dax expression formula is :

# of Products Sold under Par =

calculate(DISTINCTCOUNT('Sold vs Par'[productname]),filter('Sold vs Par',average('Sold vs Par'[AvgSoldAmount])-AVERAGE('Sold vs Par'[ParPrice])<0))+0

The issue is when I put everything in a matrix it comes out like this:

I would like the black line to sum up the number of 1's in the column, any ideas? Help is much appreciated.

[Tanushree_Kapse]

Hi @kevin757 ,

Try this measure:

Totalfix= SUMX(VALUES (Zones), # of products Sold under Par)

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks.

[Anonymous]

Sorry That didnt work. For some reason when i do that it counted the sum as 0. Would you like me to send you the file itself?

[Tanushree_Kapse]

Yes @Anonymous , pls share the file

[Anonymous]

How can I send you the pbix file?

[PaulDBrown]

Try:

# of Products Sold under Par =

SUMX('Your table',

calculate(DISTINCTCOUNT('Sold vs Par'[productname]),filter('Sold vs Par',average('Sold vs Par'[AvgSoldAmount])-AVERAGE('Sold vs Par'[ParPrice])<0))+0)

[kevin757]

So each value is now showing the # of times where the average sale price was less than the average list price.