Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamically Sum Columns based on Slicer

Alright, I have several columns:   Location Approved Budget SD Budget SF Budget LA Budget OC Budget IE Budget BFD Budget   Approved Budget should be a meausre that sums sd, sf, la, oc, ie,...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous can you put sample how your table looks like? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I'll mock up some anonymouse example and post later.

     

    parry2k  I edited op with some dax and a snapshot of the data. I can send you the bi file and spreadsheet too if that would help.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous sure send the file when ready.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k  There's no attachment permissions here? I added drive file links to the op.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  Did you ever figure out a solve?

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous hey sorry for not getting back on this. I thought Ashish_Mathur already resolved it. What is the issue with the solution he provided? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k  It looks liek his solution splits the records into new rows, and somehow(still unexplained) manages not to duplicate the other values of the record while doing it. I don't understand how he did that. I coule be missing something simple, but he offered no further explanation.

         

        Also, the the final product should still display multiple locations values if the record has them. I can't show:

        Channel 1 IE

        Channel 1 LA

         

        It would need to be

         

        Channel 1 IE,LA