Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional filtered average in line chart

Hi, The situation is as follows: I've got a line chart, with the date on the x-axis and the n of sales on the y-axis. The legend is set to Data[Country]. Country is part of a hierarchy (Country > Re...
  • AlB's avatar
    5 years ago

    Hi Anonymous 

    If I understand correctly, you always want the value for the country regardless of the level selected at the slicer. If so:

     

    Measure =
    VAR country_ = SELECTEDVALUE ( Data[Country] )
    RETURN
        CALCULATE (
            SUM ( Data[Sales] ),
            Data[Country] = country_,
            ALL ( Data[Region], Data[City] )
        )

     

    Or since you have Country in the legend, this should suffice:

    Measure =
        CALCULATE (
            SUM ( Data[Sales] ),
            ALL ( Data[Region], Data[City] )
        )

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers