Forum Discussion

robertosangi's avatar
robertosangi
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
4 years ago

This are the values johnt75 :

 

Wn = PdLCurrentWeek

Wn-1 = PdlLastWeek

 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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

  • VIJAYKUMART's avatar
    VIJAYKUMART
    Icon for Resolver I rankResolver I
    4 years ago
    IF(
    HASONEVALUE(
    Table name (unita)
    ),
    RANKX(
    ALL(
    table name of unita (unita)
    ),
    pdlcurrentweek measure
    )
    )
  • robertosangi's avatar
    robertosangi
    Icon for Helper I rankHelper 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
    Icon for Super User rankSuper User
    4 years ago

    Is it possible to share your pbix file ?

  • robertosangi's avatar
    robertosangi
    Icon for Helper I rankHelper 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
    Icon for Helper I rankHelper I
    4 years ago

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