Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I'm new to Power BI and I'd like a help for this problem:
I have a table with ID and Reason Code, like that:
ID Reason Code Only this row for ID?
1 183 False
1 1 False
1 3 False
2 183 True
3 183 True
4 183 False
4 1 False
I need to discover if the reason code 183 is followed by other reason codes. I mean, if the reason code 183 is the only row for that id.
Thanks!
Solved! Go to Solution.
Measure = COUNTROWS(Table)
Put this into a table visualization with ID. Filter Measure > 1.
Alternatively, create another table of just unique ID's. Relate the tables. Create a calculated column in this table like:
Column = IF(COUNTROWS(RELATEDTABLE(Table))>1,"False","True")
Measure = COUNTROWS(Table)
Put this into a table visualization with ID. Filter Measure > 1.
Alternatively, create another table of just unique ID's. Relate the tables. Create a calculated column in this table like:
Column = IF(COUNTROWS(RELATEDTABLE(Table))>1,"False","True")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |