Forum Discussion

shantanu97's avatar
shantanu97
Helper 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 Account','OLAP Account'[AccountCode]=300))
 
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.

3 Replies

  • az38's avatar
    az38
    Community 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
      Super 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.

  • Pragati11's avatar
    Pragati11
    Super 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