Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Measure to Sum Minutes and Filter by Year

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 DataSample Data

1 ACCEPTED SOLUTION
marcio_fornari
Resolver I
Resolver I

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'}
)

 

View solution in original post

4 REPLIES 4
FrankAT
Community Champion
Community Champion

Hi,

is the following chart what you want to  achieve?

13-02-_2020_12-48-51.png

 

Regards FrankAT

Anonymous
Not applicable

Hi, 

 

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

marcio_fornari
Resolver I
Resolver I

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.