Forum Discussion
Filter on Table Q.
In a table, I placed a filter on the amount column to be 50,000 and less. When I run SUMX() on that table, do I need to be concerned that the amount filter goes away? my sumx looks like this: ...
OK, I believe you want something like this. Assumption is that you have an [Amount] column.
<£50k = SUMX ( FILTER ( 'LTM 050K', 'LTM 050K'[pc_regionno] = 'LTM Live'[pc_regionno] && 'LTM 050K'[Amount]<50000), 'LTM 050K'[tsg_quoteprice_base]) >£50k<=£100k = SUMX ( FILTER ( 'LTM 050K', 'LTM 050K'[pc_regionno] = 'LTM Live'[pc_regionno] && 'LTM 050K'[Amount]>50000 && 'LTM 050K'[Amount]<=100000), 'LTM 050K'[tsg_quoteprice_base])
Greg,
How do I filter on a dollar amount field in a sumx()? I need to know how to say less than 50,000 and between 50,000.01 to 100,000 and several others.
<£50k = SUMX ( FILTER ( 'LTM 050K', 'LTM 050K'[pc_regionno] = 'LTM Live'[pc_regionno]), 'LTM 050K'[tsg_quoteprice_base])
Any help would be great.
OK, I believe you want something like this. Assumption is that you have an [Amount] column.
<£50k = SUMX ( FILTER ( 'LTM 050K', 'LTM 050K'[pc_regionno] = 'LTM Live'[pc_regionno] && 'LTM 050K'[Amount]<50000), 'LTM 050K'[tsg_quoteprice_base]) >£50k<=£100k = SUMX ( FILTER ( 'LTM 050K', 'LTM 050K'[pc_regionno] = 'LTM Live'[pc_regionno] && 'LTM 050K'[Amount]>50000 && 'LTM 050K'[Amount]<=100000), 'LTM 050K'[tsg_quoteprice_base])
Greg_Deckler you are the greatest Datanaut EVER!