Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys
I am looking for a help with creating column based on this logic:
count rows where values is not "Day" minus count of blank values
Could you help me with that please.
Solved! Go to Solution.
@MasterSonic , Try a dax calculated column of measure
countx(filter(Table, Table[value]<> "Day"), Table[value]) - countrow(filter(Table, isblank(Table[Value])))
@MasterSonic , Try a dax calculated column of measure
countx(filter(Table, Table[value]<> "Day"), Table[value]) - countrow(filter(Table, isblank(Table[Value])))