Forum Discussion
Julia_Mav
Helper II
Helper IIMarket Share 100%
Hi, could someone please help with the market share percentage formula? I would like it to match the one in the screenshot, and even if any filters are applied, I still want to see where 100% equals ...
Hi Julia_Mav ,
I was supposed to post this earlier but forgot to hit reply...Is Product a separate dimensions table? If so:
- what is the relationship flow of this table to the fact ta ble? - should be one to many and single direction
- which column is in the visual/slicer? From fact or dimension?
You can see in the below screenshot that your formula should work fine assuming your the correct setup is used.
Please see attached pbix for you reference.
Julia_MavHelper II
Helper IIThank you danextian.
I am using this formula, and it works when no filters are applied. However, when I filter for a specific product category, I see 100% instead of seeing the proportion it represents of all products.
Formula:
% =
% =
var _totalsalesallproducts =
CALCULATE([Sales $], ALL(‘Product'[Product Name]))
RETURN DIVIDE(
[Sales $],
_totalsalesallproducts)
danextian
Super User
Super UserHi Julia_Mav ,
I was supposed to post this earlier but forgot to hit reply...
Is Product a separate dimensions table? If so:
- what is the relationship flow of this table to the fact ta ble? - should be one to many and single direction
- which column is in the visual/slicer? From fact or dimension?
You can see in the below screenshot that your formula should work fine assuming your the correct setup is used.
Please see attached pbix for you reference.