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
Icon for Super User rankSuper User
5 years ago

Hi dadata ,

 

This type of calculation needs to be done with a SUMX fuction and this is based on the the tables you have.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.