Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 to...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    1. check the Power BI Desktop ssas engine PID in task manager

     

    2. run below command in cmd

    netstat -nao

    3. 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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

1. check the Power BI Desktop ssas engine PID in task manager

 

2. run below command in cmd

netstat -nao

3. 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.