Column Filter

Question

I have a labor cost table. One of the columns is job_id. In this column there are 5259 distinct values. And each job_id has multiple entries (rows) with data. I am trying to get the labor total per week per job id. Is there a way to group the identical job_id so that I can sum the total of each. I know I could use DAX filter and filter out each job_id individually. However since there are so many records is there an easier time saving way to do this?

anonymous · Answer

hello you could try and use the allexcept(table,table[job_id])

mweber87 · Answer

I think I may have worded my question wrong. I do not want to get rid of the whole column. I want to some how be able to add up the transaction total for each job id per week. Each job_id has multiple entries.

Thanks!

anonymous · Answer

ok can you please sample the data?and i didnt quite understand your question do you mean you want to count the job id per week?

mweber87 · Answer

Here is a sample set: This one JOB_ID has muliple Transaction_Amount entries. I want to be able to sum all of the transaction_amounts for each Job_ID. There are about 5000 different JOB_ID. My end result is to calcualte the labor per week per job id.&nbsp;Transaction_DateJOB_IDETYPETransaction_AmountThursday, August 02, 201216246LAB878.61Thursday, August 09, 201216246LAB2912.62Thursday, August 16, 201216246LAB6222.66Thursday, August 23, 201216246LAB5111.06Thursday, August 30, 201216246LAB3163.87Thursday, September 06, 201216246LAB2085.32Thursday, September 13, 201216246LAB1652.74Thursday, September 20, 201216246LAB2092.15Thursday, September 27, 201216246LAB2142.2Thursday, October 04, 201216246LAB2313.74Thursday, October 11, 201216246LAB1821.57

anonymous · Answer

hello&nbsp;mweber87&nbsp;,please give this a try:&nbsp;total = CALCULATE(SUM(powerbi[Transaction_Amount]),ALLEXCEPT(powerbi,powerbi[JOB_ID],powerbi[week]))&nbsp; &nbsp;if this helps, kindly accept as solution

Forum Discussion

Column Filter

8 Replies

Related content

Slicer for filtering several columns

Apply data to all rows in a filtered column

Adding filters to a calculated column

Filter

odata Report Level Filters Multiple Filters Same Column