how solve it using power pivot

[blb]

Dear all,

i have attached one file.

Question is inside.

Pls help to solve.

 

[p45cal]

Answer is inside.

 

[blb]

Sorry. This is not the solution i am looking for

 

[p45cal]

Oh well.

 

[blb]

There was some mistakes in previous file and i am attaching a new one

 

[AlanSidman]

create a measure in DAX

=CALCULATE(DIVIDE(Table1[Sum of Cost of sales],Table1[Sum of Sales Value]))

then filter

 

[blb]

Thanks

 

[blb]

Hello Alan,

How to filter those customers who are above 90%?

Pls help

 

[AlanSidman]

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]),""))

 

[blb]

Thanks Alan

But this measure not working.

 

[AlanSidman]

Seems to show it works in the attached.