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.

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:

     

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

      Hi inglexjc amitchandak ,
      You left an extra & between the first time and the second time.

      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]
        )
    )

       Try above.

      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

        So I think the new measure worked, no error but how to do I get the data to show on the graph?  The graph right now show blank when I have the Count Measure selected and the Court dates.