Grouping Help

[Anonymous]

Hello,

I have a below table..
userid               stock value
12345               150000
23456                190039
45678                100000
78654                 128888
 Basically I need to group stock value in respect to userid (userid should be fixed) as
1) if stock value is >=150000 then "HIGH" 
2)if stock value is <150000 & >=100000 then "MEDIUM", else "LOW"
(
IF {fixed [userid]:max([stock value])} > 15000 THEN "High" ELSEIF {fixed [userid]:max([stock value])}<= 15000 AND {fixed [userid]:max([stock value])} >= 10000 THEN "Medium" ELSEIF {fixed [userid]:max([stock value])}< 10000 AND{fixed [userid]:max([stock value])} >= 1000 THEN "Low" ELSE "Very Low" END )-----> This is the tableau formula that I need to implement in powerBi

I have used below formula but it's not working

Column = IF(CALCULATE(COUNT(Sheet1[userid]),Sheet1[stock value]>=15000),"High",(IF(CALCULATE(COUNT(Sheet1[userid]),Sheet1[stock value]<15000 && CALCULATE(COUNT(Sheet1[userid]),Sheet1[stock value]>=10000),"Medium"),"Low")

showing below error -

Can someone suggest me ?

[jdbuchanan71]

When you say 'fixed' what do you mean?  It is a set string like '654321987'?

[jdbuchanan71]

Not sure what your count is doing but if you want is as a calculated column in your table based just on the [stock value] it would be like this.

Column =
IF (
    Sheet1[stock value] >= 15000,
    "High",
    IF ( Sheet1[stock value] >= 10000, "Medium", "Low" )
)

[Anonymous]

@jdbuchanan71 i need to keep userif fixed.
basically i need to convert below tableau formula into powerbi dax measure-

IF {fixed [userid]:max([stock value])} > 15000 THEN "High" ELSEIF {fixed [userid]:max([stock value])}<= 15000 AND {fixed [userid]:max([stock value])} >= 10000 THEN "Medium" ELSEIF {fixed [userid]:max([stock value])}< 10000 AND{fixed [userid]:max([stock value])} >= 1000 THEN "Low" ELSE "Very Low" END