Forum Discussion

su1337's avatar
su1337
Regular Visitor
8 years ago

DAX Script for TOTAL and CONCAT

I need help writing a DAX script in PowerBI to take care of the following problems:   1. I need a TOTAL column that will sum the number of 'Runs' for each 'Group'. --> TOTAL for group A would ...
Need Help
su1337's avatar
su1337
Regular Visitor
8 years ago

The problem is that I need this script to run against the selected visual filters. I have the entire data filtered by date and other parameters so the script needs to take that into account.

 

I wasnt sure if there was a way to save a visual as a table because that could help the problem I am experiencing. 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi su1337,

 

That case, you can try ChrisMendoza's suggestion to create a measure which would return result conditionally taking slicer selection into account.

 

Regards,

Yuliana Gu

  • su1337's avatar
    su1337
    Regular Visitor
    8 years ago

    No this didn't work, unfortunately. 

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi su1337,

       

      Would you please share your sample .pbix file to make your scenario more clear?

       

      Regards,

      Yuliana Gu