Forum Discussion

TonicQuake's avatar
TonicQuake
Regular Visitor
4 years ago
Solved

Level of Detail Expression

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 f...
Need Help
  • TonicQuake's avatar
    TonicQuake
    4 years ago

    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.

     

TonicQuake's avatar
TonicQuake
Regular Visitor
4 years ago

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