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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
lance_6
Helper II
Helper II

Counts Not Matching: Possible Issue with relationship

I am trying to calculate the count of unique events that took place withing my data.

The issue is, the relationships aren't matching up properly(as you can see in the image with the resulting table and a couple of the measures I tried). For some reason, it isn't matching on the key for all values, and therefore treats them as a wierd hybrid composite key. 

The last image of the "Correct Result Table", is what it should look like. So basically, a group by `TaskId from History`, sum of the Session Count for each. 


I've tried a bunch of different DISTINCTCOUNT, SUMX, COUNT measures, but am overlooking something.

Any help is appreciated, thank you. 

 

Result Table and MeasuresResult Table and Measures RelationshipsRelationshipsCorrect ResultCorrect Result

 

EDIT: 

I made some progress. I managed to calculate the correct value when no slicer filters are applied. I still need to figure out how to make slicers work with this too. 

ProgressInMeasure.PNG

1 ACCEPTED SOLUTION
lance_6
Helper II
Helper II

The solution came down to using the function USERELATIONSHIP. 

 

demoR.PNG

View solution in original post

3 REPLIES 3
lance_6
Helper II
Helper II

The solution came down to using the function USERELATIONSHIP. 

 

demoR.PNG

AlexisOlson
Super User
Super User

It's not clear to me what you are expecting to see.

Thank you for pointing out how unclear my post was. I have edited it for additional clarity. 

I'm not the most advanced DAX coder, but I know in R it would be something like this code chunk:demoR.PNG

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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