calculate market share by year on a line chart

Chrisjr — Fri, 08 Sep 2023 09:02:16 GMT

Hello All,

I am having some issue to plot a graph of market share per year.

I have the following data model:

I am trying to represent the following graph:

For the bar, it is a simple count formula. And the line shart should be the market share.

However, it seems like my formula is not working because when no filters are applied, the line should be at 100 percent for each year and not like on the graph above.

Here is my dax for the makert share:

Market Share =

VAR totalIv = CALCULATE(COUNT('Main Table original'[TVA]))

VAR totalMarket = CALCULATE(COUNT('Main Table original'[TVA]), ALLEXCEPT('Main Table original', 'Main Table original'[Year]))

Return DIVIDE(totalIv, totalMarket,0)

How can I fix my formula to have the line at 100 percent when no filters are applied?

Thanks

Re: calculate market share by year on a line chart

Chrisjr — Fri, 08 Sep 2023 12:01:49 GMT

I found out the issue came from the filters in the filter pane on the right for this visual. The problem is solved

topic calculate market share by year on a line chart in DAX Commands and Tips

calculate market share by year on a line chart

Re: calculate market share by year on a line chart