Forum Discussion

janitor048's avatar
janitor048
Helper I
6 years ago
Solved

Distinct count in related table

Suppose I have the following tables Releases ReleaseID A B C   Tickets TicketID ReleaseID Stuff 1 A xyz1 1 A abc1 2 B xyz2 2 B abc2 3 B xyz3 4...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi janitor048 

     

    You can add a column like 

     

    Column = CALCULATE( DISTINCTCOUNT( Tickets[TicketID] ) )

     

    Or simply use a Measure 

    Measure = DISTINCTCOUNT( Tickets[TicketID] )
     
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi janitor048 

 

You can add a column like 

 

Column = CALCULATE( DISTINCTCOUNT( Tickets[TicketID] ) )

 

Or simply use a Measure 

Measure = DISTINCTCOUNT( Tickets[TicketID] )
 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn


 

eliPR's avatar
eliPR
Frequent Visitor
4 years ago

Mariusz,

 

Just found this. Was having the same problem as the Janitor. The thing that I don't understand is why I don't have to use the RELATEDTABLE function. I thought that calculated columns disabled filter context. Why in this case does the calculated column apply the filter from the One table to the Many table?

 

Many thanks.