Forum Discussion
DAX percentages
I'm relatively new to DAX and stuck on a particular problem. I would like to build a line chart that shows the percentage of market share of all my products for each month. I have include filters on ...
Hi Anonymous ,
According to your statement, I think there should lost [Month] column in your sample data. And I need to know the calculate logic about Revenue and Market Size. Will you determind the Market Size each month in your table? And will you need to sum the revenue each month? I think you can try ALLEXCEPT FUNCTION if you want your measure can be filtered by Filter or Slicers.
Please share a sample file without sensitive data with us and show me the result you want. This will make me easier to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.