I have this
And the Mesure is calculated by
But what I really want is that each category to have its own 100%, and not the 100% of all the categories
Does anyone knows how to do it by Set Analisys?
its actually showing in proper manner. if there is any sub category of your dimension it is possible , share your qvw.
This question is duplicated (and possibly answered) here: Percentage calculation by Set Analysis
Check this expression
Sum(SaleAmount)/SUM(total <Category> SaleAmount)
Note: Replace Category with your actual field name.
Hope this helps you.
Retrieving data ...