Forum Discussion
Solved
Measure or New Column?
Hey Pros, im new to BI so here's my dilemma, I have a sharepoint connection with several excel sheets of the same type that i have combined to make a single query. Every different sheet is a differe...
A-Aron
Add a small lookup (dimintion) table that contains two columns: Site and # of Employees. A relationship can then be created between the two tables via [Site] columns. In your visula silce by the Site column from the lookup table and the measure would be
DIVIDE ( SELECTEDVALUE ( LookupTable[# of Employees] ), COUNTROWS ( FactTable ) )
A-Aron
Add a small lookup (dimintion) table that contains two columns: Site and # of Employees. A relationship can then be created between the two tables via [Site] columns. In your visula silce by the Site column from the lookup table and the measure would be
DIVIDE ( SELECTEDVALUE ( LookupTable[# of Employees] ), COUNTROWS ( FactTable ) )
This is gold thank you !!!!!!!