Forum Discussion

Julien_F's avatar
Julien_F
Icon for Helper I rankHelper I
6 years ago

Benchmarks table in Star Schema model

Hello,    I am stuck with an issue, I mean not an issue but not enouth skills from my side to solve that one.  I checked the forum and found some path to solve it but I only solved a part of it 😕...
General Comment
Tips and Tricks
Tutorial Requests
Julien_F's avatar
Julien_F
Icon for Helper I rankHelper I
6 years ago

Hi, 

 

To give extra info, 

 

I tried with a measure  :

 

CALCULATE (
[CPM],
SUMMARIZE (level3_dimension,level3_dimension[X],level3_dimension[Y],level3_dimension[Z]),
ALL(level1_dimension[A])
)
 
+: It is in the fact
-:  - only one metric but I could create more than once so it is not a big issue 
   - If I filter the table benchmark is no more accurate , except for campaign because of the (ALL)
   - the ALL function does not accept attributes from other table like once in DIM 2 and 3 
 
Then I tried with a table : 
 
Table =
var combinetable = ADDCOLUMNS('fact',"test",RELATED(level2_dimension[X]),"test2",RELATED(level3_dimension[Y]),"test4",RELATED(level3_dimension[Z]),"test5",RELATED(date_dimension[date_date].[Month]),"test6",related(level2_dimension[w]),"test7",RELATED(level2_dimension[s]))
return
SUMMARIZE(combinetable,[test],[test2],[test4],[test5],[test6],[test7],digital_dashboard_facts[click],digital_dashboard_facts[cost],digital_dashboard_facts[impression])
 
+: I have everything
- : cannot make a relation with my star schema
It is possible to filter that tabe based on another table? Like a simple table showing: atribute like test, test2... and filter that table based on the table value? 
 
Picture below to explain better whet I want as benchmark in my "campaign" results visualisation tool and where is it from:
 

 

 
 
Thx you,
 
J.