Power BI problem in data model and in a matrix visual

[geiratatea]

Hi!

I am making a data model and reports in Power bi using REST API to get all information about workspaces, users, datasets, reports and so on. The data model is simple. The workspace table is in the middle and is related to dataset, report, user table

In my report I want to create a matrix with two levels Workspaces and Reports. I want to show number of workspaces, number of reports and number of users. It is perhaps a silly report but my problem is following. The matrix is behaving strange.When having workspacename and reportname as fields in Rows and just adding count of reports in Values, everything seems ok. But when I add number of workspaces in values, all reports is being displayed under every workspaces in the report. I was not excepting this at all.  It seems to calculate well on the top level. Why are all reports being displayed under every workspace (top level) in the matrix? A second thing is that I want to only show values on the level (you may think there is a third level users). I only want to show measure values on the level. How can I create measures that can do this? If you see anything wrong in my datamodel, please tell. Thank you

Best regards

geir

[AlexisOlson · Accepted solution]

Brukere is not filtered by Rapporter, so the count is always the same regardless of which one is on that row. It's basically doing a cross-join of workspaces and reports and computing the count for each combination whether or not the combination exists since the count isn't dependent on the report.

[geiratatea]

Hi again.

I took th easy way out of this making all relationship both directional. The performance will not suffer very much since the data amount is rather small. But I am not very satisfied. Of course it may have been easier making a classic fact table in the middle. But if I have used the original one directional relationship, I must have created dax measures that have been intelligent from what ever I have used of combinations from these other tables. The group/workspace id is the only relationship key between the tables but there exist other virtual as user email, dataset that can be used. Or what do you think?