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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
analystict
Helper I
Helper I

Measure with fields from two different tables

Hi,

 

I currently have two fields in a table called leads which are created_on and conversion_date (both date fields with existing hierarchy).

 

There is also a calculated measure which calculates the count of created_on in July and the count of conversion_date in July. What I did is I tried to sort by Month of created_on, and set both fields in the table.

 

The problem is, that conversion_date can be July and created_on can be June, which will not be counted in this case per month properly (separate measures).

 

I tried using the ALL function but it did not solve the issue, I'd appreciate some help.

1 REPLY 1
v-huizhn-msft
Microsoft Employee
Microsoft Employee

Hi @analystict,

Could you please create some sample table and list the expected result for further analysis?

Best Regards,
Angelia

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.