B blb New Member Jan 28, 2023 #1 Dear all, i have attached one file. Question is inside. Pls help to solve. Attachments SAMPLE 1.xlsx 10.3 KB · Views: 2
p45cal Well-Known Member Jan 28, 2023 #2 Answer is inside. Attachments Chandoo50904SAMPLE 1.xlsx 15.4 KB · Views: 4
B blb New Member Jan 29, 2023 #5 There was some mistakes in previous file and i am attaching a new one Attachments SAMPLE 1.xlsx 10.8 KB · Views: 3
AlanSidman Well-Known Member Jan 29, 2023 #6 create a measure in DAX =CALCULATE(DIVIDE(Table1[Sum of Cost of sales],Table1[Sum of Sales Value])) then filter Attachments SAMPLE 1.xlsx 115.2 KB · Views: 3
create a measure in DAX =CALCULATE(DIVIDE(Table1[Sum of Cost of sales],Table1[Sum of Sales Value])) then filter
B blb New Member Jan 29, 2023 #8 Hello Alan, How to filter those customers who are above 90%? Pls help
AlanSidman Well-Known Member Jan 29, 2023 #9 Maybe this will work for you. Change the DAX measure to =CALCULATE(if(DIVIDE(Table1[Sum of Cost of sales],Table1[Sum of Sales Value])>.9,Divide([Sum of Cost of sales],[Sum of Sales Value]),""))
Maybe this will work for you. Change the DAX measure to =CALCULATE(if(DIVIDE(Table1[Sum of Cost of sales],Table1[Sum of Sales Value])>.9,Divide([Sum of Cost of sales],[Sum of Sales Value]),""))
AlanSidman Well-Known Member Jan 30, 2023 #11 Seems to show it works in the attached. Attachments SAMPLE 1.xlsx 111.2 KB · Views: 2