Forum Discussion

dadata's avatar
dadata
Regular Visitor
5 years ago
Solved

Problem with different plan figures

Hello together, can you help me with a problem? I have planned figures in one table and in another table I have the distribution of the planned figures over the year in percent. The special feature ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi  dadata ,

     

    Has discussed in our message please create a new measure with the following code:

    Proportion Total= SUMX(VALUES(category[category]), [proportion])

    This should pick up the values for eaxch of the category and sum them all on the total in order to get the correct value has needed.

MFelix's avatar
MFelix
Super User
5 years ago

Hi  dadata ,

 

Has discussed in our message please create a new measure with the following code:

Proportion Total= SUMX(VALUES(category[category]), [proportion])

This should pick up the values for eaxch of the category and sum them all on the total in order to get the correct value has needed.