Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a table that sums multiple columns according to a value

Hello everyone,   I'm pretty new to PowerBI and I've been looking at my issue in this forum, but I'm not sure to find the right case. I'm trying to vizualize with a map the number of marketing act...
  • gabrielreversi's avatar
    5 years ago

    Hello Anonymous 

     

    You might want to treat this structure in the power query before doing a DAX

     

    1. make the division by the delimiter

     

     

     

     

    2. Unpivot columns

     

     

    3.  If you want, you can delete the "Attribute" columns

     

    4.Now you can count with a simpler dax

     

    I hope it helped you 🙂