Forum Discussion

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

Native Query to Pivot Large Volumes of Data

Hello!  I have a challenge for which I have not seen a resolution posted.  I have seen similar issues resolved, but none like what seems to be my normal challenge.  I am green to the more complex wor...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Put your data into a matrix table, then examine the DAX query that Power BI creates for that (including filters).  Use that query as the basis for your measure calculations.

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

Hello, Ibendlin!

 

I'm not sure what I was supposed to see but there is nothing helpful in this code from the matrix table:

EVALUATE
    TOPN(100, 'DataTable')
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Use Performance Analyzer on the Matrix visual. Copy the query and examine it.

    • stuarthokie's avatar
      stuarthokie
      Frequent Visitor
      2 years ago

      There is no query to copy which makes sense.  All I am doing is selecting rows, columns, and values to place in the Matrix:

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        That's not all you are doing.  You are also applying filters.

         

        Click Start Recording, Refresh Visuals, Copy Query.