Forum Discussion

JanaP's avatar
JanaP
Icon for Helper I rankHelper I
4 years ago
Solved

Referencing hierarchy in a different visual

Hello all, I keep sctratching my head with this task.   I have two-level hierarchy, both levels have several hundreds of elements. All data is coming from the same table, but there will be an opti...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi JanaP ,

    In my sample, Rank is a calculated column and Rank measure is a measure.

    However, I tried to create a measure like yours to rank the color, it get the incorrect result. I'm not clear why you use ISINSCOPE, I remove it and modify the formula, then get the correct result.

    In the Rank measure, no matter put the measure or calculated column, all return the correct result.


    Note: You can download my pbix attached to figure it out.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

JanaP's avatar
JanaP
Icon for Helper I rankHelper I
4 years ago

Hello v-yanjiang-msft,

 

Just wanto to say thank you again.

 

I didn't need to use this afterall as the table visual actually worked nicely with what I had. Then I had to move on to other painful measures, so sorry for the late reply!

 

Jana