Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi @ddpl ,
FIRSTNONBLANKVALUE() returns the first non-blank value of <expression> corresponding to the sorted values of <column>.
FIRSTNONBLANKVALUE(<column>, <expression>)
This function is different from FIRSTNONBLANK in that the <column> is added to the filter context for the evaluation of <expression>. It is equivalent to :
=
CALCULATE (
<Expression>,
FIRSTNONBLANK ( <Column Name>, CALCULATE (<Expression> ) )
)
I have built a simlply data sample for you to understand:
Measure 1 = FIRSTNONBLANK('Table'[Type],CALCULATE(SUM('Table'[Value])))
Measure 2 = FIRSTNONBLANKVALUE('Table'[Type],CALCULATE(SUM('Table'[Value])))
Measure 3 = FIRSTNONBLANKVALUE('Table'[Type],SUM('Table'[Value]))
Refer to:
FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ddpl ,
FIRSTNONBLANKVALUE() returns the first non-blank value of <expression> corresponding to the sorted values of <column>.
FIRSTNONBLANKVALUE(<column>, <expression>)
This function is different from FIRSTNONBLANK in that the <column> is added to the filter context for the evaluation of <expression>. It is equivalent to :
=
CALCULATE (
<Expression>,
FIRSTNONBLANK ( <Column Name>, CALCULATE (<Expression> ) )
)
I have built a simlply data sample for you to understand:
Measure 1 = FIRSTNONBLANK('Table'[Type],CALCULATE(SUM('Table'[Value])))
Measure 2 = FIRSTNONBLANKVALUE('Table'[Type],CALCULATE(SUM('Table'[Value])))
Measure 3 = FIRSTNONBLANKVALUE('Table'[Type],SUM('Table'[Value]))
Refer to:
FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://www.youtube.com/watch?v=UxzUsqjjp-Q
Proud to be a Super User!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
101 | |
65 | |
44 | |
37 | |
36 |