Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CamFi
Frequent Visitor

Row value not showing correct in Matrix

Dear Community , i have a problem with a matrix i can't seem to get correct in PBI.

 

My matrix has 3 rows

- customer

- agreement

- project 

 

It is possible for a project have the same project keys but different agreements. when i try to filter it out in the matrix, the matrix is not able to filter out correctly, because of the identical project key. in the example below there is two different agreements,  where the agreements has the same project (KOGS). this results in the agreed estimate to show up as 213 for both agreements and projects. 

 

CamFi_0-1651476798881.png

But this is wrong. 

in my database if i do the same filtering the results comes up like this - which is the correct result:

CamFi_0-1651477612481.png

the calculation used for agreed estimate is: 

Afreed estimate = CALCULATE(IF(HASONEVALUE(JIRA_Issues[Agreement_Name]) = FALSE(), SUMX(JIRA_Issues, [IssueAgreedEstimates]), blank()), Filter(JIRA_Issues, JIRA_Issues[Agreement_Name] <> blank()))
 
hope somebody can help me as i've been stuck here trying to figure out a solution for quite some time. 
cheers.

 

4 REPLIES 4
CamFi
Frequent Visitor

Thank you for the response. I'm afraid only using SUMX() do not gives me the wished result. its a pretty complex Data model, which probably is the reason why my table keeps messing with me in order to get the correct results. 

 

I wish i could give some sample but the whole thing is build in SSAS and is quite difficult to get sample from.

Icey
Community Support
Community Support

Hi @CamFi ,

 

Could you just decribe the fields used in the Matrix visual and the relationships among them? If there is some dummy data, it would be better. Let's try to reproduce it.

 

 

Best Regards,

Icey

Icey
Community Support
Community Support

Hi @CamFi ,

 

Based on the information you provided, I don't think HASONEVALUE is required in your scenario. Have you tried to just create a measure like below?

Afreed estimate =
SUMX ( JIRA_Issues, [IssueAgreedEstimates] )

 

In addition, if this doesn't work, what's your data structure? Could you give me some sample?

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

seeing the same numbers in a column usually indicates that there is a kink in your data model. Looks like you have multiple tables involved?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors