Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |