Forum Discussion
"Pivoting" a table using DAX
Pivoting a table to use in a Histogram 2 hours ago Hello, my data currently looks like this. Age Count 23 3020 45 4736 57 2987 Basically, the client counted buyers...
In the formatting options for a matrix, under 'values' theres a 'show on rows' option. If you turn this on, then put [Age Bucket] in columns and both [Count] and [Percentage] in values, then this should get you the result you want. You may have to make Count and Percentage measures, but these can just be like:
CountMeasure = SUM('YourTableName'[Count])
whitch
Resolver I
Resolver IIn the formatting options for a matrix, under 'values' theres a 'show on rows' option. If you turn this on, then put [Age Bucket] in columns and both [Count] and [Percentage] in values, then this should get you the result you want. You may have to make Count and Percentage measures, but these can just be like:
CountMeasure = SUM('YourTableName'[Count])