Forum Discussion
Dax Calculate without filter parameter
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.
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
2 Replies
- v-yulgu-msftMicrosoft Employee
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
- shihwenwuFrequent Visitor
Thank you Yuliana, I'll take a look of it :smileyhappy: