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 would like to count distinct of Order number but when visualize in the table, Order No. can be still found in two category instead it should only be included in one category..
On this table as you can see, it's okay on the total tally, but when breakdown to specific category it's not tally - it's over compared to total, since i believe some of the order no, where included on both category instead of only once..
actually there are no relationship established, since it's from one table only...
basically in power bi, i have an issue when i use category in matrix table....
In your second table, what do you put to Values field?
Are all the mentioned columns (taker_name, On PT Flag, order_no, and dups) from the same table?
actually this is the current situation.
I have an excel file to double check the data taht is in power bi..
in excel file, i have created a column to distinguish if each Order No. is distinct or Not.
in power bi, i just drag and drop the Order No. on the table and set it up in disticnt count.
name-order is many-many relationship, order-flag is one-many relationship?
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |