forrestgump
New Member
- Joined
- Sep 30, 2010
- Messages
- 22
Hi All,
I desperatly need help with powerbi. I am new to powerbi and I have 1 table with unqiue ids called headcount data and another table called survey data which has multiple ids. I have a relationship 1 to many from the headcount tble to the survey tble.
I then have 3 filters:-
Assessment Name
Rater
Leadership Expectation
I am trying to distinct counct the number of ids I have. However, When I use the leadership expectation filterand select a value my distinct count does not change. The formula I am using is 'DistinctCount(SurveyData[ID])'. Not sure where to start, any pointer would be good Thanks.
I desperatly need help with powerbi. I am new to powerbi and I have 1 table with unqiue ids called headcount data and another table called survey data which has multiple ids. I have a relationship 1 to many from the headcount tble to the survey tble.
I then have 3 filters:-
Assessment Name
Rater
Leadership Expectation
I am trying to distinct counct the number of ids I have. However, When I use the leadership expectation filterand select a value my distinct count does not change. The formula I am using is 'DistinctCount(SurveyData[ID])'. Not sure where to start, any pointer would be good Thanks.
