Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.