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

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 ?

  • 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

    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: