Where to write DAX - Semantic Model or Report

Where do you typically write your DAX code?

With the separation of the Semantic Model and the Power BI Report in Microsoft Fabric, you now have two choices:

🧊Semantic Model: You have the option to input measures under a table within the Semantic Model. These measures will then be accessible in all reports linked to that Semantic Model.
📊Report: Alternatively, you can input measures directly into your report. However, these measures will be exclusive to that specific report.

While it appears that the first option (Semantic Model) might be more practical, I’m curious if anyone has found any disadvantages to using the first option. Are there any benefits to the second option?

Can anyone share their experiences?

I write DAX in the Semantic Model

I write DAX in the Report

10 votes

2 comments