Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
This measure works (All the associations from the begining of time since the lower date in my slicer).
Association Total - Début = CALCULATE( COUNTROWS(Associations), FILTER( ALL('Date'), 'Date'[Date] < MIN('Date'[Date]) ) )
But then I wanted to add another filter to get only the associations with a certain state I got a Blank result.
Association Total - Début = CALCULATE( COUNTROWS(Associations), FILTER( ALL('Date'), 'Date'[Date] < MIN('Date'[Date]) ), FILTER( Associations, Associations[state] = "Publiee" ) )
Adding filter is doing so with a Logical AND. Why don't I have a result here ?
Solved! Go to Solution.
Hi @Anonymous,
Try one of the following measures:
Association Total - Début _ = CALCULATE( COUNTROWS(Associations); FILTER( ALL('Date'); 'Date'[Date] < MIN('Date'[Date]) ); FILTER(ALLSELECTED(Associations[State]) ; Associations[State] = "Publiee" ) ) Association Total - Début _ = CALCULATE( COUNTROWS(Associations); FILTER( ALL('Date'); 'Date'[Date] < MIN('Date'[Date]) ); FILTER(ALL(Associations[State]) ; Associations[State] = "Publiee" ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
Try one of the following measures:
Association Total - Début _ = CALCULATE( COUNTROWS(Associations); FILTER( ALL('Date'); 'Date'[Date] < MIN('Date'[Date]) ); FILTER(ALLSELECTED(Associations[State]) ; Associations[State] = "Publiee" ) ) Association Total - Début _ = CALCULATE( COUNTROWS(Associations); FILTER( ALL('Date'); 'Date'[Date] < MIN('Date'[Date]) ); FILTER(ALL(Associations[State]) ; Associations[State] = "Publiee" ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCan you explain to me why my formula wasn't working and what's up with yours ?
I really want to learn and I'm still struggling to understand some concept here.
Hi @Anonymous,
This as to do with the context of the measures, using a full table as context for a filter table will give you unexpected results since other fields in the visualizations or pages of your report can impact on the final result.
When using the ALL we are removing any context filter that the calculations have so it ignores the context given by any other columns slicers, etc from your report, using the full table the fiilters based on other context is used so you get blank values.
Check this post from SQLBI where they explain filter arguments.
also check this on the use of all in the functions.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
Without any additional information is difficult to help you can you please share a sample of your data model?
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI thought it was enough.
Here a screenshot of the sample
the status part is simply another column that I have aggragated from the query onto PBI from another table. But it is as it in PBI.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |