Same measures referencing different tables are displayed differently

[Anonymous]

Hello,

I currently have 2 measures trying to count the 'FA Date' according to each Month Year in the Dates table. The measures reference different tables but everything else, the code and relationships, are the same. Yet they display differently when in a table visual. 

MeasureB is how I want it displayed, as a counted number for each month year row. As shown in picture 3 the relationships are active. Can anyone tell me why this is happening? 

Thank you!

[Pragati11]

Hi @Anonymous ,

In the first case for Measure A, the  visual is not summarising anything right?

 Can you post sample data for TableA and TableB please?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11,

This is a bit of data from tableA and tableB respectively. data's pretty much the same, not sure why the FA date looks different as they're both in date/time format. 

I don't believe measureA is summarising anything. When they're both displayed it looks like this:

[v-juanli-msft]

Hi @Anonymous 

Because one is in datetime format, another is in date format, datetime format column can't compare with date column.

Please create another column like date_col=date(year([col_datetime]),month([col_datetime]),day([col_datetime])).

Best Regards

Maggie

[Anonymous · Accepted solution]

Hi @v-juanli-msft 

Seems I was able to fix the problem by changing the column type of FA date for both tables from date/time format to simply date format. Not sure how date/time worked for one table but not the other before, but now both are displaying correctly. 

Weird case, but thanks for your guys' help!

[Pragati11]

Hi @Anonymous ,

In your visual, from where is this MONTH-YEAR column coming?

Also, FA_DATE column format is different in both the tables.

Thanks,

Pragati

[Anonymous]

@Pragati11, 

It's from a 'Dates' table I made