Forum Discussion

ChrisPBI's avatar
ChrisPBI
Advocate III
10 years ago

Different Calculations

Hello,   I have some calculations I try to recreate within DAX, but without success yet.   My table strucutre is:                         This table is the starting point:   ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
10 years ago

ChrisPBI

 

According to your description, do you mean there is no data of 2016 in 'GGE Amounts'[GGE in kg CO2e], but table 'Models' contains data of 2016? And I can't see any relationship between table 'GGE Amounts' and 'Models' from the table structure you provided above.

 

If this is the case, the following formula should meet your needs:

Average Total GGE =
CALCULATE (
    'GGE Amounts'[GGE in kg CO2e] / DISTINCTCOUNT ( 'Models'[Product] ),
    'Models'[Release Year] <> 2016
)

If this is not the case, could you post some sample data in your case? Even better you can upload a pbix file.

  • ChrisPBI's avatar
    ChrisPBI
    Advocate III
    10 years ago

    Tryed it, does not work.

     

    Power BI did not recognize my tables.

     

    Regards,

    Chris

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      10 years ago

      ChrisPBI

       

      So which table is not recognized? Could you screenshot the relationship between the tables?:smileyhappy:

       

      Regards