Multiply Across Fact Tables with Measures

Question

Hi all,&nbsp;I have two Fact Tables, with a two measures that calculate values from each Fact Table. The Fact Tables share common Dimension Tables for the purposes of aggregation and filtering. As you can see in DAX studio (and in PowerBI) I can generate a table that calculates both measures properly in the context supplied by the Dimension Tables.&nbsp;However, what I need to do is multiply the sum of the one measure (based on one of the dimensions) by the value calculated by the other measure. Help!&nbsp;

lbendlin · Answer

Use another measure (or do the computation inline) using the ALLEXCEPT('prog Space Categories','prog Space Categories'[Name]) filter modifier.

anonymous · Answer

lbendlin&nbsp;I tried a couple of different permutations but I'm clearly not following what you're suggesting, would you mind providing a slightly more detailed explanation of what you're thinking?&nbsp;Thank you,-Robert

lbendlin · Answer

Please provide sample data in usable format.

anonymous · Answer

lbendlin&nbsp;&nbsp;Sample PBIX and Source Data file can be downloaded from here.&nbsp;Most of the terminology should match with the previous screen shot, there is a little varitation, and I simplified a couple of things. There are a couple of reference pages in the PBIX with tables on them and several relationship diagrams given there are actually three star schemas invovled.&nbsp;Screen shot illustrating what I'm attempting to accomplish.&nbsp;Thank you,-Robert&nbsp;

lbendlin · Answer

Why is Subcategories4 not a child dimension of Categories?

Forum Discussion

Multiply Across Fact Tables with Measures

10 Replies

Related content

Count Values multiplied by a measure

Multiply Measure by Column

Accumulate Measure Multiplying

multiply column and a measure - wrong total

multiplier