Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PowerBI Report- Deleting some code on DAX Query generated from Performance analyzer

Hi I have a DAXquery generated from Performance analyzer. it is restricting the number of records to 501 and inned to removed this and also how could I removed the sub toital and grand total from th...
PowerBI Pro Report Builder
PowerBI Report Server
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    The basic approach is that you want to keep the SUMMARIZECOLUMNS call inside the TOPN. If you use a tool like DAX Studio https://daxstudio.org or some other text editor which can do bracket highlighting you can then easily see where the call to SUMMARIZECOLUMNS ends and then you would just remove the bits of code before and after that (the items in red boxes below

     

d_gosbell's avatar
d_gosbell
Super User
4 years ago

The basic approach is that you want to keep the SUMMARIZECOLUMNS call inside the TOPN. If you use a tool like DAX Studio https://daxstudio.org or some other text editor which can do bracket highlighting you can then easily see where the call to SUMMARIZECOLUMNS ends and then you would just remove the bits of code before and after that (the items in red boxes below

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you very much. I'm using notepad++ text editor.