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.
In the bottom visual below, you'll notice answers of "6", but I'm looking for an answer of "8". Below I describe the setup:
In my "Store" table, notice the empty values for Store Name
I am trying to count how many other stores there are when I look at one store name (middle visual). I'm trying to use the following measure:
Thanks!
Solved! Go to Solution.
@akarasick1 , do not use store name, Try to take store id and advantage of row context
calculate(count(Stores[Store_id]),filter(all(Stores), Stores[Store_id]<>max(Stores[Store_id])))
or
calculate(count(Stores[Store_id]),filter(all(Stores[Store_id]), Stores[Store_id]<>max(Stores[Store_id])))
@akarasick1 , do not use store name, Try to take store id and advantage of row context
calculate(count(Stores[Store_id]),filter(all(Stores), Stores[Store_id]<>max(Stores[Store_id])))
or
calculate(count(Stores[Store_id]),filter(all(Stores[Store_id]), Stores[Store_id]<>max(Stores[Store_id])))
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |