New measure to calculate Market Share between tables

[Anonymous]

Hi all,

I need to calculate Market share, although I need to take in considarantion two colunms from a second table. Both table are conected. 

I would need something like that:

Market Share Year =

VAR PartyVolume =

SUM ( Table[Year] )

VAR AllVolume =

CALCULATE(SUM ( Table[Year] ), ALL(Table[Column], Table2[Column]))

Although, "All" function does not accept other table. Anyone has other idea that does not include a need of merge both 

RETURN

DIVIDE ( PartyVolume, AllVolume)

[Anonymous]

https://dax.guide/calculate/

[harshnathani]

Hi @Anonymous ,

Please share sample data and view of you model.

Regards,

Harsh Nathani

[Anonymous]

Table 1 = [id], [volume year1], [volume year2] ...

Table 2 = [id], [brand], [owner]

I have to calculate vol. market share taking into considaration table 2. Those are large set of data, for this reason I am avoiding merge.

[Anonymous]

Table 1 is not suitable for modeling in PBI. Please use UNPIVOT (around [id]) in Power Query to get it into the right shape:

id | year | volume

Best
D

[Anonymous]

I have it unpivot as well. In the unpivot case, do  how to calculate it taking in consideration the second table?

[Anonymous]

How to calculate this depends on what you understand by saying "market share." Please define in words.

Best
D