Distinct Count with filters on the page

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.
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,099,362
Messages
5,468,180
Members
406,569
Latest member
Quest_

This Week's Hot Topics

Top