Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to calculate Multiple data correctly

Hi there, I have a problem that I don't know how to google-it . Here is my problem , I have lots of product and I compare them with Rivals. I have a table like below and Some of my product wh...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

    Try to create a measure like this:

    Measure = 
DIVIDE(MAX('Table'[Product Sales]),MAX('Table'[Market Sales]))
//MAX('Table'[Product Sales])&"/"&MAX('Table'[Market Sales])

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

    If it doesn't work,  could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

    It makes it easier to give you a solution.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

Try to create a measure like this:

Measure = 
DIVIDE(MAX('Table'[Product Sales]),MAX('Table'[Market Sales]))
//MAX('Table'[Product Sales])&"/"&MAX('Table'[Market Sales])

Result:

Please refer to the attachment below for details. Hope this helps.

 

If it doesn't work,  could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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