Forum Discussion

Juan_AL's avatar
Juan_AL
Frequent Visitor
3 years ago
Solved

Hellp with DAX multiple measures

Good Morning, i have a table that includes size information and need to do a basic measure, calculate the percentage per size, what i ended up doing is pretty amateur, creating a custom column wher...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    3 years ago

    Juan_AL there is an easy and scalable way:

     

    - transform data
    - select all columns except size columns 
    - right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
    - close and apply

    Write your measure, just one, and you can filter it by any attribute (which is size) you can also view it in pivot form in matrix visual by adding attribute column on columns.

parry2k's avatar
parry2k
Super User
3 years ago

Juan_AL there is an easy and scalable way:

 

- transform data
- select all columns except size columns 
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply

Write your measure, just one, and you can filter it by any attribute (which is size) you can also view it in pivot form in matrix visual by adding attribute column on columns.

Juan_AL's avatar
Juan_AL
Frequent Visitor
3 years ago

AWESOME THIS WORKED!!