Forum Discussion

kishoresakamuri's avatar
kishoresakamuri
Icon for Advocate II rankAdvocate II
9 years ago
Solved

expression in power bi

Hi, can any one help on this how to create expression in power BI.   Sum(iif([Status] = "N/A" Or [Status] = "Out Of Scope" Or lcase([Status] = "de-scoped rbt" Or [Status]= "Deferred" Or [Status] =...
Custom Visuals
Gateways
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi kishoresakamuri,

     

    Please do not add double quotes around the number 1 and 0. Please check the DAX in my orignal post again.

     

    Best Regards,
    Qiuyun Yu

kishoresakamuri's avatar
kishoresakamuri
Icon for Advocate II rankAdvocate II
9 years ago

HI

 

Error: The function SUMX takes an argument that evaluates to numbers or dates and cannot work with values of type String.

 

This is the error  i am facing when i create  below measure .

 SUMX(dim_test_lab,IF(dim_test_lab[current_user_defined_status]="N/A" ||dim_test_lab[current_user_defined_status]="Out Of Scope" || dim_test_lab[current_user_defined_status]="de-scoped rbt" || dim_test_lab[current_user_defined_status]="Deferred" || dim_test_lab[current_user_defined_status]="Invalid","0","1")) -SUM(dim_test_set[baseline_number]) + SUMX(dim_test_lab,IF(dim_test_lab[current_user_defined_status]="N/A" ||dim_test_lab[current_user_defined_status]="Out Of Scope" || dim_test_lab[current_user_defined_status]="de-scoped rbt" || dim_test_lab[current_user_defined_status]="Deferred" || dim_test_lab[current_user_defined_status]="Invalid","1","0"))

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi kishoresakamuri,

 

Please do not add double quotes around the number 1 and 0. Please check the DAX in my orignal post again.

 

Best Regards,
Qiuyun Yu

  • kishoresakamuri's avatar
    kishoresakamuri
    Icon for Advocate II rankAdvocate II
    9 years ago

    Hi

     

    Is there any live chat to calrify doubts.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      This is forum support :smileyhappy:. If you have any question about this issue, please feel free to post.

       

      If you want to dedicated support, you can open a support ticket at the bottom of this site: https://powerbi.microsoft.com/en-us/support/ .

       

      Best Regards,
      Qiuyun Yu

       

  • kishoresakamuri's avatar
    kishoresakamuri
    Icon for Advocate II rankAdvocate II
    9 years ago

    Hi,

    How can rank function defined in power bi actually i am new to Power Bi.

     

    RANK() OVER (PARTITION BY TC.Project_id, TC.Release_id,TC.release_cycle_id, RELC.sprint_name, C.test_set_name,C.test_set_id ORDER BY TC.test_name,C.test_set_id) as baselined_test_rank

     

    Regards,

    Kishore Sakamuri.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi kishoresakamuri,

       

      As this issue is different from the original issue which should be a second issue, please post it as a new thread. Thanks for your understanding and support. :smileyhappy:

       

      By the way, you can find the syntax of DAX RANKX() from here https://msdn.microsoft.com/en-us/library/gg492185.aspx .

       

      Best Regards,
      Qiuyun Yu