Forum Discussion

inglexjc's avatar
inglexjc
Icon for Post Patron rankPost Patron
3 years ago
Solved

Color coding graph based on age.

I was able to get a new table created to group children by ages.     and was told to create the following measure    Count Age = VAR __AgeBandMin = SELECTEDVALUE('Query1'[Min] ) VAR _...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    Hi inglexjc amitchandak ,
    Just replace the comma with && 'Legal Files'[Age] >= __AgeBandMin &&.

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

  • inglexjc's avatar
    inglexjc
    3 years ago

    Nathaniel_C  don't worry about it I went a different direction since it wasn't working.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

inglexjc , try like

Count Age =
VAR __AgeBandMin = SELECTEDVALUE('Query1'[Min] )
VAR __AgeBandMax = SELECTEDVALUE('Query1'[Max])
return
CALCULATE(
COUNTX(Filter('Legal Files',
'Legal Files'[Age] >= __AgeBandMin,
'Legal Files'[Age] <= __AgeBandMax
),'Legal Files'[Age]) )

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi inglexjc amitchandak ,
      Just replace the comma with && 'Legal Files'[Age] >= __AgeBandMin &&.

      Let me know if you have any questions.

      If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
      Nathaniel

      • inglexjc's avatar
        inglexjc
        Icon for Post Patron rankPost Patron
        3 years ago

        Nathaniel_C  which comma.  If I use:

        Count Age =
        VAR __AgeBandMin = SELECTEDVALUE('Query1'[Min] )
        VAR __AgeBandMax = SELECTEDVALUE('Query1'[Max])
        return
        CALCULATE(
        COUNTX(Filter('Legal Files' &&
        'Legal Files'[Age] >= __AgeBandMin,
        'Legal Files'[Age] <= __AgeBandMax
        ),'Legal Files'[Age]) )
        I get this error: 

        If I use:

        Count Age =
        VAR __AgeBandMin = SELECTEDVALUE('Query1'[Min] )
        VAR __AgeBandMax = SELECTEDVALUE('Query1'[Max])
        return
        CALCULATE(
        COUNTX(Filter('Legal Files'&,
        'Legal Files'[Age] >= __AgeBandMin &&
        'Legal Files'[Age] <= __AgeBandMax
        ),'Legal Files'[Age]) )
        I get this error:

        And if I use this code: 

        Count Age =
        VAR __AgeBandMin = SELECTEDVALUE('Query1'[Min] )
        VAR __AgeBandMax = SELECTEDVALUE('Query1'[Max])
        return
        CALCULATE(
        COUNTX(Filter('Legal Files'&,
        'Legal Files'[Age] >= __AgeBandMin,
        'Legal Files'[Age] <= __AgeBandMax
        )&&'Legal Files'[Age]) )
        I get this error: