Forum Discussion

dogbob's avatar
dogbob
Regular Visitor
2 years ago

Creating a measure for same metrics but different dimensions

I have a collection of tables that have various cuts of the same metrics using different dimensions. Simplified example:   Is there a way I can create a single measure to calculate the averag...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  dogbob ,

 

Thanks for the reply from amitchandak , please allow me to provide another insight: 

Here are the steps you can follow：

1. Use Enter data for text input - used as a slicer.

2. Create measure.

Measure =
SWITCH(
    TRUE(),
    MAX('Slicer_Table'[Slicer])= "Region",DIVIDE(SUMX(ALL('Table1'),'Table1'[Leads]),SUMX(ALL('Table1'),[Ad Spend])),
    MAX('Slicer_Table'[Slicer])= "Message",DIVIDE(SUMX(ALL('Table2'),'Table2'[Leads]),SUMX(ALL('Table2'),[Ad Spend])),
    MAX('Slicer_Table'[Slicer])= "Device",DIVIDE(SUMX(ALL('Table3'),'Table3'[Leads]),SUMX(ALL('Table3'),[Ad Spend])))

3. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly