Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am triying to use EXACT to check if Brands are different or not
I have a big table and i dont know how to check if the manufacturer in each category is unique.
I started with an old formula based on numbers and i think earlier does not belong here.
My idea is to check all the manufacturer in each category and give true or false.
error: EXACT needs at least two arguments i guess i need some kind of an array of all the different manufacturer for each category.
Category | Manufacturer | columns with dax |
Car | BMW | true |
Car | VW | true |
Car | GM | true |
Truck | Ford | true |
Truck | MAN | true |
Truck | Mercedes | true |
Bus | Bus1 | false |
Bus | Bus1 | false |
Bus | Bus2 | true |
@craftbeer , Try a new column like
new column =
var _cnt = countx(filter(Table, [Category] = earlier([Category]) && [Manufacturer] = earlier([Manufacturer])),[Manufacturer])
return
if(_cnt =1, true(), false())
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |