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.
Hi team,
I need to create a calculate column, to check wheather it is parent or not based on "Sno =0"
if sno =0 with respective Parent Id then "Yes" else "No"
Thanks in Advance,
Solved! Go to Solution.
You can try this column expression.
HasParent =
IF (
CALCULATE (
COUNTROWS ( Table ),
ALLEXCEPT ( Table, Table[ParentID] ),
Table[Sno] = 0
) > 0,
"Yes",
"No"
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can try this column expression.
HasParent =
IF (
CALCULATE (
COUNTROWS ( Table ),
ALLEXCEPT ( Table, Table[ParentID] ),
Table[Sno] = 0
) > 0,
"Yes",
"No"
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Anonymous Column = IF([Sno]=0,"Yes","No") ?
NO.
1.Consider with Parent ID , Sno =0, then it is parent.
2. If Sno<>0 then it is not parent.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |