Forum Discussion

Finnishflash's avatar
Finnishflash
New Member
3 years ago

Calculating relation ship between two visual

Could somebody guide me on below problem.

I have built to table from A, B, C, D, E, F, table 1 contains values A,D,C,E, table 2 contains only F, how can I create a measure that calculated table 1 divided by table 2

 

EXAMPLE

                     TABLE1           TABLE2      MEASURE

group1         A,B,C,D=5,      E=1          20%

group2         A,B,C,D=20     E=2          10%

....

 

THEN CREATE A TABLE THAT SHOWS

group1      20%

group2      10%

....