Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 Relation
Using Calculate without filter got the correct result
Wrong result without Calculate
Compared with measure(left table) and Calculate Tabel(right table)
Thanks in advance.
Solved! Go to 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
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
Thank you Yuliana, I'll take a look of it
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |