Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have two tables: 'Deals' and 'Dates' with couple many to one inactive relationships (for example based on 'Deals'[Created Date] and 'Deals'[Won Date]).
I ran two queries in Power BI Desktop using DAX Query View:
1.
EVALUATE
{
CALCULATE(
COUNT( 'Deals'[Deal ID] ),
USERELATIONSHIP( 'Dates'[Date], 'Deals'[Won Date] ),
FILTER(
'Deals',
'Deals'[Product] = "XYZ" &&
NOT ISBLANK('Deals'[Won Date])
)
)
}
2.
EVALUATE
{
CALCULATE(
COUNT( 'Deals'[Deal ID] ),
FILTER(
'Deals',
'Deals'[Product] = "XYZ" &&
NOT ISBLANK('Deals'[Won Date])
)
)
}
I am getting two different results, which makes me wondering why if there are no outer filters applied and how does calculate work in the bacground to obtain different outputs here.
I have went through different 'How does CALCULATE work' articles but could not find one that covers my case.
Thank you in advance!
Hey @Chakravarthy,
thank you for your reply, do you know (what Im most interested in) where is the difference in the output in my two queries coming from and why is it happening?
Hi @filipbobczuk -
Please try below code:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |