Forum Discussion

iqbalck's avatar
iqbalck
Frequent Visitor
9 years ago

How to use a calculated measure in a matrix/table visualisation

I have a database where I have the country, region etc in columns, and in another column attributes like Sales, Gross Profit, other costs etc and in the last column the values. I am trying to calculate the Gross Profit as % of Sales in a calculated measure and use this measure in the Matrix / Table visualisation. In the table I have in the rows Sales, Gross Profit, other costs and so on (from attributes column of database) and in columns I have the values for these. I want to add Gross profit % of Sales in the rows and in the column the value of this. When I try to do this I get the calculated measure on a separate column. Any help appreciated.

Need Help

5 Replies

    • iqbalck's avatar
      iqbalck
      Frequent Visitor
      9 years ago

      Thanks. But the data I have is as above. and the visualisation table is as below:

       

       and in the above visualisation table I need to add the calculated measure (gross profit / Sales) which will be 36.3%

      • tringuyenminh92's avatar
        tringuyenminh92
        Icon for Memorable Member rankMemorable Member
        9 years ago

        Hi iqbalck,

         

        I think with ALL method you could calculate sum of total:

         

        (%) = DIVIDE(SUM(Sheet1[Value]),CALCULATE(SUM(Sheet1[Value]),all(Sheet1)))

         

        Hope this is what you are expecting.:smileyvery-happy: