Forum Discussion
Matrix with filter to Dax measure code
Hi
My workflow is that I often start with a matrix and filter the matrix to find total value. I would like to see the code behind so I can convert to a measure. Is that possible, are there som tool that can help me with this?
Hi Anonymous ,
1. check the Power BI Desktop ssas engine PID in task manager
2. run below command in cmd
netstat -nao3. check the tcp port for ssas engine
4. open SQL Server Profiler, connect to this ssas engine with server name
local:<port number>5. create a new trace and run, then you could find the behind code
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
lukiz84Memorable Member
daxstudio or sql profiler
Hi Anonymous ,
1. check the Power BI Desktop ssas engine PID in task manager
2. run below command in cmd
netstat -nao3. check the tcp port for ssas engine
4. open SQL Server Profiler, connect to this ssas engine with server name
local:<port number>5. create a new trace and run, then you could find the behind code
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
saudansariHelper II
You can use the Tabular Editor, it will help you move the measures from one file to another if needed - https://github.com/TabularEditor/TabularEditor/releases/tag/2.21.1