ALL and ALLSELECTED not returning the total

[katrine_d2o]

Hi,

I am trying to calculate a simple percentage of total sales per category. For example bottle of red wine of all wine.

I have tried ALL dax and ALLSELECTED dax:

ALLSELECTED RevPrProdCategory =

CALCULATE(

    [NetRevenue],

ALLSELECTED(POSItemDetails[ProductCategory])

)
 But, I always get the revenue per item. I am working with a live dataset, not sure if that matters. I cannot seem to find a lot of information about working with live data.

Am I doing something wrong? Any suggestions?

[katrine_d2o]

Thank you @AntrikshSharma, for responding. But it still does not work. This is from a restaurant where you have product categories. The article (description) belongs to a product categor and a pos category. There is no particular sort order.

As an example, what I want to find out:
The chardonnays sold is X percent of all white wines. For this I need to use the total of white wine, being a POS Category.

[katrine_d2o]

Hi again, @AntrikshSharma 

I think I figured it out - I was looking at it wrong. I needed to use description instead of category in the formula. In essence I was looking for the total of all the items/description in a category.

Thanks again

[AntrikshSharma · Accepted solution]

@katrine_d2o Description column is sorted by ProductKey or any other column? If yes, then include that column as well in the ALL/ALLSELECTED.