In my current role I am using Excel 2010 with PowerPivot
One of the reports I produce is a tabular pivot table with one row for every row in the source table. Instead of dragging multiple columns into the row labels area, thus slowing an already slow environment, I am using measures to show the values, as long as only one value can appear within the current filter context (which is unfiltered).
Therefore, I have only one column in the row label area and multiple measures in the values field which are appearing as columns on the pivot table.
This is the measure I am using.
While this works quite well, my issues is that I have created lots of new columns in my fact table which I know is inefficient. I tried integrating RELATED functions but haven't managed to create one which works.
I am looking for a measure which performs the same role as this one but does not require a helped (RELATED) column in my fact table.
Any assistance would be appreciated.
One of the reports I produce is a tabular pivot table with one row for every row in the source table. Instead of dragging multiple columns into the row labels area, thus slowing an already slow environment, I am using measures to show the values, as long as only one value can appear within the current filter context (which is unfiltered).
Therefore, I have only one column in the row label area and multiple measures in the values field which are appearing as columns on the pivot table.
This is the measure I am using.
Code:
MeasureName:=IF(
COUNTROWS(VALUES(Table[Column]))=1,
VALUES(Table[Column])
)While this works quite well, my issues is that I have created lots of new columns in my fact table which I know is inefficient. I tried integrating RELATED functions but haven't managed to create one which works.
I am looking for a measure which performs the same role as this one but does not require a helped (RELATED) column in my fact table.
Any assistance would be appreciated.
Last edited:
