Power BI calculated column Help

[arifulice09]

I have a data table (see the attached) , I am trying to get a calculated column based on some condition 

Condition( if all FeeType is Hourly for a particular project then for that project the result will be Hourly, if all is NoBilling then NoBilling else Fixed) but I am not getting the result.

 

[Samarth_18 · Accepted solution]

Hi @arifulice09 ,

Create a column like this:-

Column_ = 
var _hourly = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "Hourly" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _nobill = COUNTROWS(FILTER('Table (3)','Table (3)'[Feetype] = "NoBilling" && 'Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

var _proj = COUNTROWS(FILTER('Table (3)','Table (3)'[projectid] = EARLIER('Table (3)'[projectid])))

return SWITCH(TRUE(),
_hourly = _proj  ,"Hourly",
 _nobill = _proj,"No Biling",
"Fixed")

Output:-

Thanks,

Samarth

[arifulice09]

@Samarth_18 thank you :-), its working fine.

[goncalogeraldes]

Hello there @arifulice09 ! Check if this works for you:

Desired Result =
SWITCH (
    TRUE (),
    DISTINCTCOUNT ( 'Table'[Feetype] ) > 1, "Fixed",
    SELECTEDVALUE ( 'Table'[Feetype] )
)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[arifulice09]

@goncalogeraldes Thanks for your reply, using the above code only giving the result of "Fixed" value.