If possible please explain with examples,,,
Thanks in Advance.
Go to Solution.
Hi @ddpl ,
FIRSTNONBLANKVALUE() returns the first non-blank value of <expression> corresponding to the sorted values of <column>.
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 :
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]))
FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Docs
Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Proud to be a Super User!
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.