Forum Discussion
A-Aron
Helper I
Helper IMeasure 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 ) )
tamerj1
Community Champion
Community ChampionA-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-AronHelper I
Helper IThis is gold thank you !!!!!!!