Forum Discussion

afbraga66's avatar
afbraga66
Helper III
5 years ago

Sort Matrix by dynamic column value based on filters

Hi,   I have a requirement to sort a matrix by the last possible month value, 7 in the example below. The issue is that Power BI only sorts by the total and that is not what I want.     I ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

afbraga66 Perhaps:

Today Month = 
    VAR __Date = MAX('DOWNTIME'[DIA_FABRIL])
RETURN
    IF(ISBLANK([mDuration (min)],
      BLANK(),
      CALCULATE([mDuration(min)], KEEPFILTERS(DOWNTIME[MES_FABRIL]=MONTH(__Date)))
    )
afbraga66's avatar
afbraga66
Helper III
5 years ago

Hey Greg_Deckler ,

 

I have tried it, but it is not working. Still giving the same result as the previous one unfortunately.

Probably because the ISBLANK() evaluates against the values of all months in that expression?

Thank you.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    afbraga66 What about this version?

    Today Month = 
    VAR __Date = MAX('DOWNTIME'[DIA_FABRIL])
    VAR __mDuration = CALCULATE([mDuration(min)],KEEPFILTERS(DOWNTIME[MES_FABRIL]=MONTH(__Date)))
RETURN
    IF(ISBLANK(__mDuration),
      BLANK(),
      __mDuration
    )
    • afbraga66's avatar
      afbraga66
      Helper III
      5 years ago

      Hey Greg_Deckler ,

       

      Same result unfortunately 😞

       

    • afbraga66's avatar
      afbraga66
      Helper III
      5 years ago

      Hey Greg_Deckler ,

      Sorry to bother but any news on this topic?