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 have a column in TableA that is a concatenate of two fields: ProductID and CountryID. In TableB, I have another column that is also a concatenate of ProductID and CountryID. I am looking for a formula that would tell me if a record in this column in TableA, has an equivalent to a record in the column in TableB. In excel I would use a Countif, 0 meaning no record, and 1 (or more) if there were more records. And then I would probably nest that with an IF function so that it could just be true or false.
How can I sort this in DAX?
Thank you!
Solved! Go to Solution.
I ended up doing this, but I feel it's a bit convulted. I couldn't get the above solutions to work.
I ended up doing this, but I feel it's a bit convulted. I couldn't get the above solutions to work.
An example based on sample data with the expected result would help understanding the requirement. Try this:
1. Place TableA[Column1] in a table visual
2. Create this measure and palce it in the visual:
Measure =
IF (
CALCULATE (
COUNT ( TableB[Column1] ),
TREATAS ( SELECTEDVALUE ( TableA[Column1] ), TableB[Column1] )
) > 0,
TRUE (),
FALSE ()
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
@Unicorn_Tech , You can use COUNTX
https://docs.microsoft.com/en-us/dax/countx-function-dax
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 |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |