Forum Discussion

Mseeram's avatar
Mseeram
Frequent Visitor
4 years ago
Solved

Calculate min based on the selected values

Hello everyone, I am trying to get the minimum amount based on selecting few subvendors which I could able to achive it, now I need to create an other table comparing each subvendor with the ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Mseeram ,

     

    I created three measures.

    Target(min) =
CALCULATE (
    MIN ( 'Sample'[Cost] ),
    FILTER (
        ALL ( 'Sample' ),
        [Item Code] = MAX ( 'Sample'[Item Code] )
            && [Item Desc] = MAX ( 'Sample'[Item Desc] )
    )
)

    Diff = SUM('Sample'[Cost])-[Target(min)]
    Percentage = DIVIDE([Diff],SUM('Sample'[Cost]))

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Mseeram ,

 

Could you tell me if your problem has been solved?

If it is, kindly Accept the helpful reply as the solution. More people will benefit from it.

I downloaded the attachment of A and found that %Var is not displayed. I completed it.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mseeram's avatar
Mseeram
Frequent Visitor
4 years ago

Hi Anonymous 

Thanks for your response, if you see my original post I have 2 screen shots, 1st one I am selecting some sub vendors and taking min among them (not overall min) and in 2nd screen shot I have to put each sub vendor againest the selected min from the 1st screen shot and calculate the $difference and %difference.
I am reattaching the files here.
https://cscishell-my.sharepoint.com/:x:/g/personal/mseeram_csci_build/ERMK_KdRfGRFn3IAkTWsx14BQ5jnUMLFF_3mEt6J-kXnBQ?e=BkYG9q
https://cscishell-my.sharepoint.com/:u:/g/personal/mseeram_csci_build/ETsukNaxxbNJrqzeej5b4G8BMIp4Cmrd-7CuGVE01623zA?e=2GRJkS

Thanks,
Murali

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Mseeram ,

     

    I created three measures.

    Target(min) =
CALCULATE (
    MIN ( 'Sample'[Cost] ),
    FILTER (
        ALL ( 'Sample' ),
        [Item Code] = MAX ( 'Sample'[Item Code] )
            && [Item Desc] = MAX ( 'Sample'[Item Desc] )
    )
)

    Diff = SUM('Sample'[Cost])-[Target(min)]
    Percentage = DIVIDE([Diff],SUM('Sample'[Cost]))

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.