Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Adding condition for DAX calculate and filter expression

Hi all,   I am working on creating a Title card for my dynamic report and need some help.   I have a list of holding companies and I want to create an expression that will allow the user to filte...
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_Deckler Hi Greg, I'm not sure I fully understand the measure. I just want to add "All Accounts" at the end of the measure? 

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

      Anonymous Not much to go on but maybe:

      Title = 
  VAR __TOTAL_ROWS = COUNTROWS(DISTINCT(ALL('Table1'[account])))
  VAR __CURRENT_ROWS = COUNTROWS(DISTINCT('Table1'[account]))
RETURN
  IF(__TOTAL_ROWS = __CURRENT_ROWS(
    "All accounts",
    "Report C-" & CALCULATE(FIRSTNONBLANK(Table1[account], TRUE () ), FILTER (Table1, Table1[HoldingCompany] = TRUE ())
  )