Multiple different aggregations within the same column

Hi all,

I believe I have a unique challege on how to show something:

• Measure slicer:
  • Measure A (SUM)
  • Measure B (SUM)
  • Measure C (SUM)
  • Measure D (DIVIDE)
• Unit of Measure slicer:
  • Dollars
  • Euros
  • Local Currency

And as an example, each measure (A, B, C, D) can have their corresponding units of measure. For example, measure A can be in Dollars, Euros and Local Currency, measure B, C, D as well (basically a cartisian join).

This is how the data looks like in fact table:

Dimensional tables are connected (one - to - many) to fact table like shown here (sorry for blacking out the data 🙂 😞

Visualtion has to look like following:

Now, I have following question:

1. How do I make a SINGLE measure that will either DIVIDE or SUM
   
   1. for example, if Measure A is selected, measure should SUM, and if Measure A and measure D is selected, measure should SUM and DIVIDE

Hopefully, I have explained it clearly enough. 🙂

Thank you all!