cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RanjanThammaiah
Helper V
Helper V

Cross Count

Hi All,

 

Can some one help me to solve the below Problem. Not sure this can be done using BI. Guidance would be much appreciated.

Basically trying to See the Cross Account Count by SSL(Should not be counting the Duplicates)

From this eg. Where BTS(SSL) to PAS(SSL) is 1 Account(ABC) where as PAS(SSL)to BTS(SSL) is 2 Account(ABC & XYZ)

 

 

Cross selling.png

Sample data

 

Opp IDOpp NameSSLAccount NoAccountNameBuyingSellingTotal Deal Value
1983796MGSBTS1011471332ABCBuying                     100,000
2054157MNSPAS1011471332ABC Selling                       40,000
2095519MPSPAS1011471332ABCBuying                        20,000
1913522MNQBTS1011471332ABC Selling                       50,000
1913522MNQBTS1011471335XYZ Selling                       10,000
        
  BTSPAS    
 BTS 1    
 PAS2     
Basically trying to See the Cross Account Count by SSL(Should not be counting the Duplicates)     
From this eg. Where BTS(SSL) to PAS(SSL) is 1 Account(ABC) where as PAS to BTS is 2 Account(ABC & XYZ) 

 

 

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@RanjanThammaiah - Is there a reason for SSL to be in both rows and columns? I mean, it can be done with a disconnected table most likely but a simple table/matrix visual with SSL and the default distinct count of Account No provides the correct results.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@Greg_Deckler Thanks for the response, basically need to undersatnd the Cross metrix numbers.

I have many SSL Where in the above  Eg. BTS to PAS. The greyed out shound not have any counts(0).

It should go from Columns to Row(BTS to PAS, PAS to BTS).

 

Hope i haven't explained it well.,

 

Regards,

Ranjan

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors