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'm trying to find all ID values containing a certain value. Example given here:
In this example I need to find all ID values that contain a "D" and then assign a "1" to all rows with one of those ID values, including rows that don't actually contain "D".
Solved! Go to Solution.
Try this measure:
Countrows D =
VAR _D =
CALCULATETABLE (
VALUES ( 'FactTable'[Cat1] ),
ALLEXCEPT ( FactTable, FactTable[ID] )
)
RETURN
IF ( "D" IN _D, 1, 0 )
If you don't need the rows with 0, close the brackets after the 1 in the return IF expression
Proud to be a Super User!
Paul on Linkedin.
Try this measure:
Countrows D =
VAR _D =
CALCULATETABLE (
VALUES ( 'FactTable'[Cat1] ),
ALLEXCEPT ( FactTable, FactTable[ID] )
)
RETURN
IF ( "D" IN _D, 1, 0 )
If you don't need the rows with 0, close the brackets after the 1 in the return IF expression
Proud to be a Super User!
Paul on Linkedin.
Hi @PaulDBrown!
If it's not too much to ask, could you take a look at the question I posted here. I'm still having trouble with it. Thanks!
Thank you!
This does seem to work. I have some additional questions but I'll make a seperate message for those.
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 |