Forum Discussion

shantanu97's avatar
shantanu97
Icon for Helper I rankHelper I
6 years ago
Solved

Issue with DAX measure calculation

Written a DAX measure but I don't know why it is not showing values? Can anyone help me to fix this error?   Cost of goods sold(COGS) = CALCULATE(SUM('OLAP CUBE_Finance_WB'[Amount]), FILTER('OLAP A...
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    You are right az38 . Account count is in Text format but when I tried to put " " in DAX so It gives me login credential error.

    shantanu97 , Please put 300 in double quotes because it's a text.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi shantanu97 ,

 

Looks like your relationships are not right therefore te filter in this measure is not working.

 

Your current relationship: OLAP ACCOUNT to OLAP CUBE FINANCE WB table

But, in your dax you are trying to use filter other way round.

 

Please work on your data model to get the calculations right.

 

Thanks,

Pragati