How to get percentage to display correctly

[Anonymous]

I'm pulling data from Nav and I have to display Orginal Profit % per each project.

I have three tables currently and Orig. Profit % is located at Planning Line-table

Job

     |

      Job Task

                  |

                    Job Planning Line

The thing is that I want to look it like this, but don't seem to get the percentages right because PBI counts the sum automatically

Project 1	Original Project %
Project 2	Original Project %

But if put Don't Summarize then it looks this, well at least the percentages are right, but now there are multiple lines for each project.

Project Number 1	Original Project %
Project Number 1	Original Project %
Project Number 2	Original Project %
Project Number 2	Original Project %

 How would I get this working as I intend to?

[az2451]

Hi @Anonymous,

this seems very normal.

How do you want the data to be shown.

Can you make an example with dummy values?

Regards,

Berat

[Anonymous]

Hi, I'd like to display like this.

Well, since I have the budget cost and budget price I can calculate it per project instead of the field from Nav which causes trouble.

[v-chuncz-msft · Accepted solution]

@Anonymous,

DAX Studio can be used to capture queries, you may have a look.