Forum Discussion

ChrisPBI's avatar
ChrisPBI
Icon for Advocate III rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft 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
Icon for Advocate III rankAdvocate 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
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    ChrisPBI

     

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

     

    Regards