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,

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