Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 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 🙂
gabrielreversi
5 years agoFrequent Visitor
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 🙂