Dax Calculate without filter parameter

[shihwenwu]

Hi all,

I created a calculate table hoping to make calculations based on buyer emails.

I got what I want using Calculate function with putting any filter parameter.

I check the result again by creating measure and they are all correct.

But what confusing me is that how does it work?

How does dax know that the result should be filter by buyer email when Calculate is applied?

Data RelationUsing Calculate without filter got the correct resultWrong result without CalculateCompared with measure(left table) and Calculate Tabel(right table)

Thanks in advance.

[v-yulgu-msft · Accepted solution]

Hi @shihwenwu,

Maybe you could refer to this blog for detailed description about CALCULATE() function.

The Calculate Function in Power BI

Best regards,

Yuliana Gu

[shihwenwu]

Thank you Yuliana, I'll take a look of it