Forum Discussion
Create column filled with measures
I have multiple measures (six in total, representing quarters of a year Q1,Q2,etc) that are counts from a column. I would like to create a new column with these six values and add the the column to a...
Hi prateekraina,
Thank's for the reply. The thing is that I don't really want to see the table on the canvas. I wan't to have the table as data in the FIELDS part and then use it to draw a bar chart like this:
Thanks, Oskari
Hi OskariNi,
Well, that will simply increase the data size of the report.
You can create the bar chart without having to do so.
Still, if you want to do that only, then you need to create Calculated Columns instead of measure to achieve that. However, i doubt that you present DAX formula may not work as is, you will have to change it to get same results as measure.
If you want to go with ideal scenario, you must use measures.
Prateek Raina