The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
See below. Need a custom column that returns the difference between the min and max count of the 'count_column' grouped by the 'group_column'. And then return a boolean. Something like:
CALCULATE(
MIN(
COUNT(table[count_column])) -
MAX(
COUNT(table[count_column])),
ALLEXCEPT(table,table[group_column])
) = 0
group_column | count_column |
A | text |
A | text |
B | text |
B | text |
C | text |
where is your customer ID?
Not sure what you're referring to. For additional clarity. I'm using matrix visual that needs to be filtered if a value (column_count) changes over time. Hence the min minus max. So there is no cutomer ID. Each row has a date associated with it. The count of items for that calandar week needs to be compared across time and then a boolean value is returned if that value has changed.
User | Count |
---|---|
24 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |