Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How would I create the "Is Loyal v2" column in the Table View using DAX based on the first two columns? I want the outcome to equal "No" for all rows if there is a row that equals "No" for the ID in the first column.
I know I can achieve this with Power Query, but wondering if it's possible in the table view.
ID | Is Loyal | Is Loyal v2 |
1 | Yes | No |
1 | Yes | No |
1 | Yes | No |
1 | No | No |
1 | Yes | No |
2 | Yes | No |
2 | No | No |
2 | Yes | No |
2 | Yes | No |
2 | Yes | No |
3 | Yes | Yes |
3 | Yes | Yes |
3 | Yes | Yes |
3 | Yes | Yes |
3 | Yes | Yes |
Solved! Go to Solution.
As a calculated column...
Is Loyal v2 =
CALCULATE(
MIN([Is Loyal]),
ALLEXCEPT(loyalTable, loyalTable[ID])
)
Proud to be a Super User! | |
Hi @TJK, go to Modeling ->New column
Is Loyal v2 =
IF(
CALCULATE(
COUNTROWS('Table'),
'Table'[ID] = EARLIER('Table'[ID]),
'Table'[Is Loyal] = "No"
) > 0,
"No",
"Yes"
)
Did I answer your question? If so, please mark my post as the solution!✔️
Your Kudos are much appreciated! Proud to be a Responsive Resident!
Hi @ahadkarimi ,
You're formula is giving me the same result as the "Is Loyal" column. It's only showing "No" when "Is Loyal" is equal to "No". I would like it to show "No" for all rows for the given ID.
Is Loyal v2 =
IF(
CALCULATE(
COUNTROWS('Table'),
'Table'[ID] = EARLIER('Table'[ID]),
'Table'[Is Loyal] = "No"
) > 0,
"No",
"Yes"
)
As a calculated column...
Is Loyal v2 =
CALCULATE(
MIN([Is Loyal]),
ALLEXCEPT(loyalTable, loyalTable[ID])
)
Proud to be a Super User! | |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
42 | |
37 | |
22 | |
22 | |
21 |