Forum Discussion

cool_333's avatar
cool_333
Frequent Visitor
3 years ago
Solved

dax help

Hi all, I'm trying to calculate 25*108075 = 2701875 instead I'm getting results as 2746186 which is incorrect. I have different categories columns in the table not sure how this is getting filtered, ...
DAX Power BI
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi ,  cool_333 

    According to your description, you want to calculate 25*108075 = 2701875.

    It is difficult to see the problem with just a picture. DAX is a statement for filtering context, and different filtering may calculate different results.

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi ,  cool_333 

According to your description, you want to calculate 25*108075 = 2701875.

It is difficult to see the problem with just a picture. DAX is a statement for filtering context, and different filtering may calculate different results.