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.
I have a table in which I have this information :
ID | title |
ZE | a |
ZE | b |
ZE | c |
AD | z |
AD | b |
BT | a |
BT | e |
I want to have this result by a calculated column or measure dax.
ID | title | b |
ZE | a | ok |
ZE | b | ok |
ZE | c | ok |
AD | z | ok |
AD | b | ok |
BT | a | |
BT | e |
Thanks
Solved! Go to Solution.
Hi @forbi ,
Please try:
b =
VAR _count_b =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALL('Table'),
'Table'[ID] = EARLIER('Table'[ID])
&& 'Table'[title] = "b"
)
)
VAR _result =
IF(_count_b=1,"ok")
RETURN
_result
If [id] contains more than one "b" that also matches the condition, you can change the last judgment above from =1 to >=1.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @forbi ,
Please try:
b =
VAR _count_b =
CALCULATE(
COUNTROWS('Table'),
FILTER(
ALL('Table'),
'Table'[ID] = EARLIER('Table'[ID])
&& 'Table'[title] = "b"
)
)
VAR _result =
IF(_count_b=1,"ok")
RETURN
_result
If [id] contains more than one "b" that also matches the condition, you can change the last judgment above from =1 to >=1.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
You need to create an extra table (id table) and don't link them
identifier ok =
CALCULATE (
SELECTEDVALUE ( identifier[b] ),
TREATAS ( VALUES ( tbl[ID] ), identifier[ID] ),
TREATAS ( VALUES ( tbl[title] ), identifier[title] )
) & ""
-----
download files from here
https://dropmefiles.com/Pv33J
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |