Measure to Sum Minutes and Filter by Year

[Anonymous]

Hello All,

I need some help in adding a new measure to sum a column (Number of Minutes) and filter by different column (Year).

Sample data in attached screenshot, I need your assitance to add a measure for total minutes in 2019 and and 2020. 

Looki

Line and Clustered column chart 

Columns - Number of calls (2019 & 2020)

Line - Number of Minutes (2019 & 2020)

Sample Data

[FrankAT]

Hi,

is the following chart what you want to  achieve?

Regards FrankAT

[Anonymous]

Hi, 

Yes, similar to it, but separate line for 2019 Minutes and 2020 Minutes.

[marcio_fornari · Accepted solution]

I Think this is works for you: 3 Measures for example.

Total Minutes 2019 = 
    CALCULATE(
      SUM(Table[Minutes]);
      Table[Year] = 2019
)

Total Minutes 2020 = 
    CALCULATE(
      SUM(Table[Minutes]);
      Table[Year] = 2020
)

Total Minutes 2019 & 2020 = 
    CALCULATE(
      SUM(Table[Minutes]);
      Table[Year] = in {'2019', '2020'}
)

[Anonymous]

Hi, Many thanks.. Exactly what I was looking for, thanks again.