Forum Discussion
Finnishflash
3 years agoNew Member
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%
....
1 Reply
- amitchandakSuper User
Finnishflash , Once you have common dimensions, you can divide the measure across two tables and view them across common table columns