Forum Discussion

javif_84's avatar
javif_84
Icon for Helper I rankHelper I
2 years ago
Solved

Help with Market Share calculation in DAX

Hi guys,   I am getting mad with this one... Hope you can help. Basically I need a table showing  Years,MS%, %GR in a same table so I create them as Values and add them in the matrix. I get someth...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Ritaf1983.

     

    Hi javif_84 ,

     

    Please try the following DAX formula:

    LAST MAT MS%1 = DIVIDE([LAST MAT],CALCULATE([LAST MAT],ALLSELECTED('Output')))

    Result:

     

    Best Regards,
    Zhu

     

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

javif_84's avatar
javif_84
Icon for Helper I rankHelper I
2 years ago

OK sorry even in this dataset the formula does not work which is great 🙂

 

Absolute figures and MS

 

This is what I get in Excel

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from Ritaf1983.

 

Hi javif_84 ,

 

Please try the following DAX formula:

LAST MAT MS%1 = DIVIDE([LAST MAT],CALCULATE([LAST MAT],ALLSELECTED('Output')))

Result:

 

Best Regards,
Zhu

 

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

  • javif_84's avatar
    javif_84
    Icon for Helper I rankHelper I
    2 years ago

    Thanks so much Zhu! One question, what was the issue? Why a sumx wasn t giving me the proper result?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi javif_84 ,

       

      In DAX, measure is computed based on context, which means that they determine their values based on the current filter conditions and the context. Directly referencing a measure ensures that it is calculated correctly in the current context. SUMX function is an iterative function that calculates and sums each row in a table. Using SUMX function is summing each row. But the calculation of the measure depends on the context of the entire visual rather than a single row of data.

       

      Best Regards,
      Zhu

       

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