Hi @greeshma p , Create a table with the following data: IDType 1 <30 2 <60 Now add the following measure to your model: 30 60 values = SWITCH(SELECTEDVALUE('Time'[ID]), "1" , [30 divided by Count of count], "2", [60 divided ...
hiii guys i have created a visualization graph in that want to group <30secs bar graphs together and <60secs bar graphs together.to do so i have tried to change the axis and all i have tried can some help me how can group them. i am attaching my power ...
Greeshma, You sent me a MP indicating you are using a calculated column to filter values. I think in your case, you should use a measure (instead of a calculated column) : CALCULATE(SUM(Waiting time column), FILTER(Table, Waiting Time > 60 seconds)) ...
Hi Greeshma, Can you show you table composition and how the concerned columns are computed ? ------------------------------ Vincent L. Chartered accountant - Expert-comptable ------------------------------
Hiiii guys I am facing an error of circular dependence in my query i have created a calculated column to do my calculation I need to divide 2 columns to get the output percentage Divide('phone call Data'[waiting tym < 60 secs],'phone call Data'[count ...