several agents create calls with customers and log the date, the type etc.. i want to count the calls made on the same day (for every day), then i want to know the accumulation of calls per day (like, there were 3 occurances (dates) with 5 calls made on that day, 8 occurances with 1 call a day etc.)
i want to display the accumulation of calls with an x-axis (1 -> max calls per day) and an y-axis (accumulation of calls per day). thats all well and easy for the totals of calls per day, but i need to be able to filter the visual for agents (user), call type etc. using slicers or drill-through action.
In fact, current power bi does not support to create dynamic calculate column/table based on filter/slicer. Dax formula which you used to get selected value will be fixed(it will calculate on 'whole' table) and return the static result.
Community Support Team _ Xiaoxin Sheng If this post helps, please consider Accept it as the solution to help the other members find it more quickly Learning resources: Power BI