Forum Discussion
insert measures on a pivot
Hi, i would like to create a Pivot with some measures that i created in the model. the measures are not always the same because these change based on the selection of the column "CodCommesssa". ...
Alberto95 - to create a calulated column, select the table in the "Data" tab and then select "New Column" from the toolbar. Paste your measure DAX into the new formula area that appears.
You can then use a Matrix visual with both new columns in columns and rows, and your measures for the amount of "Ricavi Tot" and the counting (use COUNTROWS( 'Table' ) for this) in the Values section.
The will appear side-by-side rather than above and below. But it is the closest you will get to you desired visual.
If this helps, please accept as the solution so others with the same challenge can find it.