Forum Discussion

RK9009's avatar
RK9009
Frequent Visitor
5 years ago

Dax Help

Greeting PBI Community, I need help with this dax measure studentID status abc123 status 1  abc123 status 2 abc123 status 3 abc123 status 4 bca231 status 2 bca231 status ...
Fowmy's avatar
Fowmy
Super User
5 years ago

RK9009 

 

No need to specify, when you drop this measure against the status in a table visual as I did, it calculates based on the status value. The status1 is lower than status2 and so on. You can add more status values  in the same order if needed. 

let me know if you need any help after the testing  it. 

RK9009's avatar
RK9009
Frequent Visitor
5 years ago

Does it work if it is a has to follow a hierarchy as in 

All id in A being first to all ID in D.

 

 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    RK9009 



    I did not fully understand your question, why don't you try,

     

    as per your sample, it works 

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn