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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AIS
New Member

Measure shown as sum of all rows, need it by date

I'm very new to PowerBI, apologies if this has been answered somewhere obvious. I separated out my data and am trying to get two measures (PPC Leads and Email Leads) in the same chart by month. The "Email Leads" measure seems to be showing the sum of all values for each month instead of the monthly sum:

 

2017-02-08 13_16_31-Clipboard.png

 

How can I make "Email Leads" show sums for each month? I've checked the settings and it looks like they're all the same between the two measures.

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@AIS

 

You need a calendar table to related both tables.

 

The easy way is Go to Modeling and New Table

 

MyCalendar=CalendarAuto()

 

Now related this table (MyCalendar) with PPC Lead Date and Email Lead Date

 

After that use This Date (in My Calendar) to Axis in your Chart-

 

 

 

 




Lima - Peru

View solution in original post

6 REPLIES 6
FarhanAhmed1984
Resolver III
Resolver III

Can you please share the Calculations of both measures. ?

I'm not sure how to show that...I don't have any calculations here really, just data sourced from tables. Here is how I have my visual set up:

2017-02-08 13_53_43-Check In Meeting with TJ - OneNote.png

This is what my data looks like (sources are both text):

 

 

2017-02-08 13_56_05-Clipboard.png2017-02-08 13_56_26-SINS Search Email dashboard - Power BI Desktop.png

 

 

Vvelarde
Community Champion
Community Champion

@AIS

 

Are these tables related?

 

You can view in Relationship Section

related.png

 

 

 




Lima - Peru

 

They look like this. I constructed the "PPC" and "Email" tables based on filtered data from the "RAW DATA" table. Thanks for the help!

 

2017-02-08 14_20_07-SINS Search Email dashboard - Power BI Desktop.png

Vvelarde
Community Champion
Community Champion

@AIS

 

You need a calendar table to related both tables.

 

The easy way is Go to Modeling and New Table

 

MyCalendar=CalendarAuto()

 

Now related this table (MyCalendar) with PPC Lead Date and Email Lead Date

 

After that use This Date (in My Calendar) to Axis in your Chart-

 

 

 

 




Lima - Peru

That worked - thank you very much!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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