Forum Discussion
column inside a measure
Hi ,
Actually i have 3 Table (A,B,C) both table A and B have ID column and Table C is just used for me to create whole report measures into it so What i need is to get a column name PEOPLE_NAME from table A in Table c with some filter inside a measuer Like
MEasure 1 = calculate (PEOPLE_NAME,filter('TableB',TableB[ID]))
need to do something like this AS i know we Have to use aggrigate fucntion to get a column in a Measure but here as Names are involved can not do that any idea how to accomplish the task
1 Reply
- amitchandak
Super User
Anonymous , If if non of them can act as a dimension create a common people dimension first
Then if you need something if a Not in B
Measure
var _a = countrows(A)
var _b = countrows(A)
return
countrows(filter(Values(people[PEOPLE_NAME]), not(isblank(_a)) && isblank(_b) ) )
Change filter as per need
