Generating a Data Bus Matrix according to Kimball in Power BI / Tabular Editor 3

[Flixy04]

Hi together,

i would like to generate a Data Bus Matrix according to Kimball in Power BI / Tabular Editor 3.
I am looking for a measure that recognizes which KPI can be analyzed in which dimension.
This should be a help for the users of the dashboard and should look like this:

Thank you!

Flixy04

[Flixy04 · Accepted solution]

Hi together,

i found a solution. in SSAS you can see the dependencies in a Tabular Model with this SQL statement:

SELECT * FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY

You can load this tabel in your model and after some transformation it is possible tho show the Data Bus Matrix.

Regards

Flixy04

[v-jingzhang]

Hi @Flixy04 

I'm afraid a measure cannot do this job. I took a quick look at all DAX functions and felt that none of them could do that. You need to recognize which KPI can be analyzed in which dimension and record the results in a data source manually. Then import it into Power BI Desktop and use a Matrix visual to display the results directly. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.