Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I read a few similar threads but couldn't find one that would work with my measure. I made this measure using Quick Measure to find the most recent date where a column equals "Fail".
Solved! Go to Solution.
Thank you everyone for the help. I ended up going a different route that can be seen here.
Solved: Re: Count by criteria - Microsoft Power BI Community
StephenGW
Thank you everyone for the help. I ended up going a different route that can be seen here.
Solved: Re: Count by criteria - Microsoft Power BI Community
StephenGW
Hi @StephenGW ,
Glad to know that your issue is solved now,could you pls mark the reply as answered to let more people find the solution.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
You'll need to use either
ALL( Data[Audit Month], Data [Audit Year]), Data[Pass/Fail]="Fail")
or
ALL( Data[Audit Month], Data [Audit Year]), Data[Audit Date] )
if you want to remove the filter on Month and Year slicer and also filter Audit_Date or Pass/Fail column
Hi @StephenGW !
Please try using ALL() function to remove the filter cotext from [Audit Month] & [Audit Year] columns.
Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data, Data[Audit Month], Data [Audit Year]), Data[Pass/Fail]="Fail"))
Regards,
Hasham
Thanks but that makes the visual not display. The details say "The rport measure 'Data'[Fail Date] has a syntax or semantic error at line 1, position 53, reported by Analysis Services: 'Multiple table arguments are not allowed in the ALL function. Here is a screenshot of my filters and the table.
I want the Location and Department slicers to apply to the measure but not the year or month. Only thing in the table is 'Data'[Area] and the measure.
Thanks for the quick reply.
StephenGW
ALL can take a table or columns but not both. Try removing the first argument in ALL:
ALL ( Data[Audit Month], Data[Audit Year] )
Thanks @AlexisOlson for correcting it.
@StephenGW So it could be like this;
Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data[Audit Month], Data [Audit Year]), Data[Pass/Fail]="Fail"))
Regards,
Hasham
This counts what I want but it includes the slicers.
Hi @StephenGW ,
Try:
Fail Date = CALCULATE(MIN('Data'[Audit Date]), FILTER(ALL(Data), Data[Pass/Fail]="Fail"))
No need to emphasis 2 fields after All,just choose all the table.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
This approach can yield really bad performance if the table has lot of million rows and lot of columns, Alberto Ferrari/Marco Russo always recommends using the minimum number of columns in an ALL Statement.
I think we are getting close but now it's not seeing the column Pass/Fail in the filter for Data[Pass/Fail]="Fail". In the formula box it underlines it in red and says Cannot find name 'Pass/Fail'. I tried deleting the column and renetering to see what it offered for column names and it did not have any Pass/Fail column. Why is this column now missing?
Edit: If this helps the data is coming from a spreadsheet in my OneDrive for Business
Thanks
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
82 | |
64 | |
63 | |
56 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |