Forum Discussion

Adairene's avatar
Adairene
Frequent Visitor
5 years ago
Solved

A Calculated Column for Cross-Business Opportunity Distinct Count - HELP!

Hello!   A simple problem, but cannot wrap my head around it - could somebody please help? What is the correct DAX formula for the "Cross-Business Opportunity Distinct Count"? Thank you!   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Adairene ,

    Here are the steps you can follow：

    1. Create measure.

    Measure =
CALCULATE(DISTINCTCOUNT('Table'[Opportunity Owner Business]),FILTER(ALL('Table'),'Table'[Opportunity]=MAX('Table'[Opportunity])))

    2. Result.

     

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Adairene , how is Cross-Business Opportunity Distinct Count is defined. what logic behind 2 and 1

Adairene's avatar
Adairene
Frequent Visitor
5 years ago

Hello amitchandak,

 

The definition is that it should count the unique occurences of a "Opportunity Owner Business" under each "Opportunity". Are you able to help with this?