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.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

shantanu97 

there is access restriction to your OLAPs in attached pbix, but I can suggest that your AccountCode is a text

If so, either change date type to number or use quotas in sentence

Cost of goods sold(COGS) = CALCULATE(SUM('OLAP CUBE_Finance_WB'[Amount]), FILTER('OLAP Account','OLAP Account'[AccountCode]="300"))
  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    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.