Forum Discussion

Debbie_Montique's avatar
Debbie_Montique
Frequent Visitor
8 years ago
Solved

Countrows from Distinctcount from another column

Hi All,   I'm trying to do a count of all values from one column... got that, not a problem.  The problem is that I need my new count based on a distinct count from another column.  For example col...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Debbie_Montique

     

    Good to know that you can solve your question.

     

    Please accept the solution to others con use you.

     

     

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

Debbie_Montique

 

Hi, a few ways to obtain:

 

Alternative 1:

 

 

Alternative 2. Using a Measure:

 

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[SalesOrder] ) )

 Add a Visual and use B2B/B2C Column and the measure

 

Regards

 

Victor

Debbie_Montique's avatar
Debbie_Montique
Frequent Visitor
8 years ago

But I'm going to need the counts of distinct B2B and B2C to do invoicing, and I cannot pull that from a Visual can I?