Hello,
I have a customer-per-month dataset, and i need to create a calulated column (not measure) where for each customer returns an aggregation of its total turnover. The tricky part here is that i need to have a slicer in my dashboard, where the user selects specific months to be included in this calculation.
Please note that it need to be a calculation in column, not a measure, because i need to use this numbers as axis in a scatter chart.
I tryed a calculated new table having both ways connection with my primary customer-per-month table, on customer_id . It did returned on customer level the required aggregation, but it partially ignored the slicer, as it was containing total turnover, of the correct month's customers.
My code was the following:
TOTAL_CUSTOMER_TURNOVER =
SUMMARIZE(
'CUSTOMERS_MONTHLY_ACT'
,CUSTOMERS_MONTHLY_ACT[CUSTOMER_ID]
,"Turnover",sum(CUSTOMERS_MONTHLY_ACT[MONTHLY_TURNOVER]) )
I seems that if i used some kind of filtering in my calculated table it will be wroking fine, but i just can't figure it out.. Can someone help me please?
Many thanks in advance!
