Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Combine filters, Filter exception,

Hi all,   I want to show all tasks from a sellected month and the Delayed tasks from previous months. Thanks!   Month Status Task January Delay A January On track B January Do...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    You should be able to do this:

     

    Count Measure = 
  VAR __Table = 
    ADDCOLUMNS(
      'Table',
      "__Selected",[Selected]
    )
RETURN
  COUNTROWS(FILTER(__Table,[__Selected] = 1))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg_Deckler,

 

Thanks for the reply!

It's not working here, is this correct? 

&& [Status]="Delay"

 

Regards,

Lucas

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Oh, if you are using this in a measure, you need to wrap that with an aggregation like && MAX([Status]="Delay"
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler,

     

    Thank you it worked, but now I have one problem. I need to count the number of tasks that are labeled as "1" and show it in a graph by Status, as it is not a collumn it's not working. Can you help with it? 

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      You should be able to do this:

       

      Count Measure = 
  VAR __Table = 
    ADDCOLUMNS(
      'Table',
      "__Selected",[Selected]
    )
RETURN
  COUNTROWS(FILTER(__Table,[__Selected] = 1))
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Greg_Deckler ,

        Thank you very much, It works!

         

        But now I noticed one thing, I can't select more than one month, do you know how to solve this?

         

        Is there a function to conver all values between MAX and MIN?