Forum Discussion

PBIUWO's avatar
PBIUWO
Icon for Helper III rankHelper III
7 years ago
Solved

Count rows in relation to another column?

I have 1 table that has the column, Order Number, Item Code, and Shipping ID.    I am trying to get the count of unique Shipping ID to the Order Number.  The data:   Hoping to create a col...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi PBIUWO ,

     

    To create relationship between tables as below.

     

     

    Then we can create a calcualted column to get the result we need.

    count of shipping id = 
CALCULATE ( DISTINCTCOUNT ( data[Shipping ID] ), RELATEDTABLE ( data ) )

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi PBIUWO ,

 

To create relationship between tables as below.

 

 

Then we can create a calcualted column to get the result we need.

count of shipping id = 
CALCULATE ( DISTINCTCOUNT ( data[Shipping ID] ), RELATEDTABLE ( data ) )