Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Grouping Help

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 ?



Need Help

3 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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 

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    5 years ago

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