CODEWITHSUNDEEP
powerbipowerbi-desktopbusiness-intelligence
AB21
AB21

Reputation: 385

Data distribution not showing in power bi though the models have relationship

I have two models: Data and Product Master. Their relationship is defined as joining by Category Name:

enter image description here

I have written measure as:

2. Total sales = SUM(Data[Sales Amount])

It appears as:

enter image description here

Then I checked:

enter image description here

It shows:

enter image description here

Why is not the distribution of category name and Name and showing in table?

Then after If , I uncheck measure 2. Total sales then it will show:

enter image description here

Why is the distribution of of category name and Name not showing according to total sales?

Upvotes: 0

Views: 264

Answers (1)

msta42a
msta42a

Reputation: 3741

Check your relationship. Are you sure that you connect the correct columns? Data Type is that same? Any white space on one side of the relationship? "Tshirt " instead of "Tshirt"

Upvotes: 1

Related Questions