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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur  It looks like you you just split the list values of lcoation into new rows. I've tried this in a couple ways. Unless I do it in my source data, I always end up with duplicated budget numerals, which means that every lead name with multiple locations would have double or triple the budget once combined. 

 

I see that your Approved Budget matches mine, so how did you do that? Assuming I can replicate that in my real data, I woudl then need to group by lead name for display. I can't show duplciate lead names in my tables. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Review the approved budget measure.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes, I can read the simple DAX. I don't see how that answers my concern. I don't mean to be rude, but if you aren't goign to take the time to explain your solution, then why reply?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        Neither do i mean to be rude but please learn by self-reading.  With limited time that i have (as is also the case with you), I'd rather answer more questions than "spoon feed" others.