Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiply Across Fact Tables with Measures

Hi all,   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...
Help Requested
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    lbendlin 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?

     

    Thank you,

    -Robert

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      Please provide sample data in usable format.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        lbendlin 

         

        Sample PBIX and Source Data file can be downloaded from here.

         

        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.

         

        Screen shot illustrating what I'm attempting to accomplish.

         

        Thank you,

        -Robert