Level of Detail Expression

[TonicQuake]

Hi All, 

I'm trying to get to the total number of distinct advisers in a team when looking, when an indiviudal is selected. 

This is what I have tried: 

In the TeamMember Count field, I'm expecting it to display 9 as there are only 9 members in the Life team that have a Total > 0

Thanks

Rob. 

[TonicQuake]

@amitchandak Thank you for your response. 

I have attached  sample pbix file, with very basic made up data, but the same style of how the my acutal tables are linked. 

In the example file attached, I would expect the TotalAdviser Count to equal 4 as only 4 out of the 10 advisers have quoted in that Team. 

pbix file uploaded to file.io

https://file.io/sWAwmrfxLpsT

Thanks

[amitchandak]

@TonicQuake ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[TonicQuake · Accepted solution]

I've manged to figure it out, by getting it to calculate the first part then, Calculate the All and AllExcept, Calculation below:

TotalAdviser Count =

CALCULATE(

CALCULATE(

DISTINCTCOUNT(Adviser[AdviserName])

,FILTER(Outcome,[Total Leads] > 0)

)

,ALL(Adviser)

,ALLEXCEPT(AdviserFloor,AdviserFloor[AdviserFloorName])

)

Thanks All.