Forum Discussion

bartvana's avatar
bartvana
Iron Contributor
Feb 11, 2022
Solved

Power Pivot relations

This is somehow related to my previous question "Basic Power Pivot question (why does the relationship "not work")", but I have a similar problem in a new file (see attached). I have a fact table "I...
BI & Data Analysis
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 11, 2022

    bartvana All credit should go to SergeiBaklan , for the solution in the thread you linked. I just took the same approach to create the following measure that I called "DA":

    =CALCULATE(
   SUM(tCompDetailAll[StDevAvg]),
   TREATAS (
      VALUES(tItemVendor[SKU]),
      tCompDetailAll[SKU]
   )
)

     

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 11, 2022

bartvana All credit should go to SergeiBaklan , for the solution in the thread you linked. I just took the same approach to create the following measure that I called "DA":

=CALCULATE(
   SUM(tCompDetailAll[StDevAvg]),
   TREATAS (
      VALUES(tItemVendor[SKU]),
      tCompDetailAll[SKU]
   )
)

 

 

Resources