Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Share based on total for specific value

Hello,   I have the following matrix: I have a column in my table named "Exists" which has value "1" if a brand exists in a store. I want to calculte the Share for each store compared to the Count...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Create measures

    total exsits = SUM('Table'[exsits])

exsits in country = CALCULATE(SUM('Table'[exsits]),FILTER(ALLSELECTED('Table'),'Table'[market]="country"))

% = [total exsits]/[exsits in country]

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    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
    6 years ago

    Hi amitchandak ,

     

    Thank you for your reply. Sorry if my question was not clear enough. I need to have the value for 'Exists Country' on each row of the matrix in order to calculate the share. So in the area marked with red I want to have the value 29 on each row.

     

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous ,Can you share sample raw data in table format

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        I attached a sample of the table. Unfortunately, I can not put the data here so I modify it. Hope it is understandable.

         

        Thank you!