Percentage of total from 2 table

[CC2019]

Hi Team,

I have three tables - Customers (customer details), Feedback (Feedbacks given by customers), Sales(sales by customers). Id column in Customers table is used to link tables. I want to find percentage of sales by each customer type(customer type is a column from feedback table).

3 type of customers are "P", "D","Ps".

I used following calculation

Pr_Sales% =

var total=

CALCULATE(SUM(Sales[Sale]),

Feedback[Type]="P")

Return

DIVIDE(total,SUM(Sales[Sale]))

It gives me a value. But I want three percentages be summed upto 100.

I have attached the screenshots. Kindly help

[v-diye-msft]

Hi @CC2019 

Would you mind trying to add below measure, then calculate the percentage:

SUMSales = CALCULATE(SUM(Sales[Sale]),FILTER('Feedback', Feedback[Type]="P"||Feedback[Type]="D"Feedback[Type]="Ps"))

Pr_Sales% =var total=
CALCULATE(SUM(Sales[Sale]), Filter('Feedback', [Type]="P"))
Return
DIVIDE(total,SUMSales)

[CC2019]

Hi @v-diye-msft ,

It returns the same result as in the screenshot. Still not adding to 100%

[v-diye-msft]

Hi @CC2019 

Could you please share your simple worksheet/dummy pbix preferable? 

[amitchandak]

As the customer has more than one feedback, it is not rolling up to 100%. So you need to select only one feedback. Or need do changes to get sales also counted more than once if there is more than one feedback.