Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Ranking values comparing two weeks

Hi,    I have one question regarding the possibility to rank values based on a comparison between weeks.   Here the problem: I have this kind of table: First of all i want to have first ...
Need Help
  • robertosangi's avatar
    robertosangi
    4 years ago

    Seems is not working anyway johnt75 

     

    Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure 


    Could you please rewrite formulas as you expected? Thanks

     

robertosangi's avatar
robertosangi
Helper I
4 years ago

This are the values johnt75 :

 

Wn = PdLCurrentWeek

Wn-1 = PdlLastWeek

 

johnt75's avatar
johnt75
Super User
4 years ago

You need the RANKX functions to work over the UT table, not the Date table

  • VIJAYKUMART's avatar
    VIJAYKUMART
    Resolver I
    4 years ago
    IF(
    HASONEVALUE(
    Table name (unita)
    ),
    RANKX(
    ALL(
    table name of unita (unita)
    ),
    pdlcurrentweek measure
    )
    )
  • robertosangi's avatar
    robertosangi
    Helper I
    4 years ago

    Seems is not working anyway johnt75 

     

    Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure 


    Could you please rewrite formulas as you expected? Thanks

     

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Is it possible to share your pbix file ?

  • robertosangi's avatar
    robertosangi
    Helper I
    4 years ago

    johnt75 unfortunatelly is not possible. Maybe could be possible to have a short meeting with screen sharing

  • robertosangi's avatar
    robertosangi
    Helper I
    4 years ago

    I solved the measurement problem. Only rank doesn't Work... Here the situation: