Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
User | Count |
---|---|
14 | |
9 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |