Improving performance of measure with multiple filter conditions

[Anonymous]

Hello everyone!

So, I have the following measure:

V.Received =
var same_day = FILTER(Table,YEAR(Table[LT_opened_at])&MONTH(Table[LT_opened_at])&DAY(Table[LT_opened_at])=YEAR(Table[qu_date])&MONTH(Table[qu_date])&DAY(Table[qu_date]))

return
CALCULATE(count(Table[hrc_number]),same_day)))

I also used the logic of "&&" logic to compare year, month and day but is slow as well.

My table has like 8M rows, it takes a long time to load when this measure is inside.
My table has date as rows, and this measure Bbasically its checking the number of rows where the lt_opened_at day matches the qu_date day that is being used in the table as row.

Any better idea on how to make such a measure?

Thank you!

[Vvelarde]

@Anonymous

Hi, Do you have a table like this?

And you want to compare Row by Row If OpenedDate is equal to Qu_date?

Regards

Victor

[Anonymous]

Hello,

Yes, the qu_date will be used in the table row by row with the measure I mentioned.

Best Regards

[Vvelarde]

@Anonymous

Hi, try with:

Measure =
CALCULATE (
    COUNT ( Table1[HRCNumber] );
    FILTER ( Table1; Table1[OpenedDate] = Table1[Qu_Date] )
)

Regards

Victor

[Anonymous]

I am trying to avoid that, cause I will need to change the data type on the database side and I need it for some calculations.. (knowing the time).  That is why I was doing this workout, but I think I do not have any other choice, maybe making two columns where one I just delete the extra details and make as you said