Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
Can someone help with why this is not working? Goal: Cur & Pre are using the key indicator to create a yes or no flag
I am then using the return portion of the dax to give me the count of all the loans on the cur report and not on the prev report.
Solved! Go to Solution.
Hi @22LACMT ,
According to your screenshot, I think "cur" amd "pre" part are both measures which need to return results in a table. So you need to filter in a table to use these conditions. The syntax should be FILTER(Table, Filter Expression).
Jeopardynewsinceprior =
VAR cur =
IF ( ImmediateJeopardy[Measure_fpnjeo], "Y", "N" )
VAR pre =
IF ( ImmJPastMonth1[Measure_Jeopastfpn], "Y", "N" )
RETURN
CALCULATE (
COUNT ( MTData[FPN] ),
FILTER ( ALLEXCEPT ( MTData, MTData[Data] ), cur = "Y" && pre = "N" )
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @22LACMT ,
According to your screenshot, I think "cur" amd "pre" part are both measures which need to return results in a table. So you need to filter in a table to use these conditions. The syntax should be FILTER(Table, Filter Expression).
Jeopardynewsinceprior =
VAR cur =
IF ( ImmediateJeopardy[Measure_fpnjeo], "Y", "N" )
VAR pre =
IF ( ImmJPastMonth1[Measure_Jeopastfpn], "Y", "N" )
RETURN
CALCULATE (
COUNT ( MTData[FPN] ),
FILTER ( ALLEXCEPT ( MTData, MTData[Data] ), cur = "Y" && pre = "N" )
)
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
10 | |
4 | |
3 | |
3 | |
2 |