Forum Discussion
ergocorp
Helper II
Helper IIHow to put suppliers into amount brackets/pots
Hi all I was wondering of the community could help. I have a lot of spend data, but let's simplify it. Let's say I have: Supplier Spend a 4 b 5 c 3 d 5 a 3 e 3 c 1 ...
HI ergocorp ,
There must not be a relationship between this two tables, you just need to add the notation quote to the table name change your measure to:
Total Suppliers by tier = COALESCE ( COUNTROWS ( FILTER ( SUMMARIZE ( 'Query1', 'Query1'[Supplier Name], "@TotalValue", [Sum of Spend] ), [@TotalValue] <= MAX ( 'Table'[Max] ) && [@TotalValue] >= MIN ( 'Table'[Min] ) ) ), 0 )
ergocorpHelper II
Helper IIHi MFelix ,
It is indeed called Table:
I just had a thought, could it be that there are no defined relationships between Query1 (where the measure is) and Table?
MFelix
Super User
Super UserHI ergocorp ,
There must not be a relationship between this two tables, you just need to add the notation quote to the table name change your measure to:
Total Suppliers by tier =
COALESCE (
COUNTROWS (
FILTER (
SUMMARIZE ( 'Query1', 'Query1'[Supplier Name], "@TotalValue", [Sum of Spend] ),
[@TotalValue] <= MAX ( 'Table'[Max] )
&& [@TotalValue] >= MIN ( 'Table'[Min] )
)
),
0
)