Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

DAX help Re: calculated measure

Hello,   Heirarchy of my sales data is as follows, EVP->RVP->DM->Branch->Customer->Part.. I would like to set up a measure that counts if a customer has a profit gain at a certain value (Red).   ...
Need Help
  • cosborn1231's avatar
    cosborn1231
    10 years ago

    Hi Rynoh17,

     

    I usually will leverage a calculated column in this case and build a associated measure.

     

    Sum of Extended = IF([Sales Amount]>100,1,0)

    Count of Customers = CALCULATE(DISTINCTCOUNT('Power BI'[Customer ID]),FILTER('Power BI','Power BI'[Sum of Extended]=1))

     

    Applying your different filter contexts should show at which branch your customers who meet that extend sales requirement fall.

     

    Within the table/matrix  you can also leverage conditional color formatting within the values tab to enforce color threshholds.

     

    I hope this helps.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous

 

Please try the solutions provided by CahabaData and cosborn1231. If you still cannot get the expected result, maybe you can give some sample data and the expected output to us.

 

Best Regards,

Herbert

Anonymous's avatar
Anonymous
Not applicable
10 years ago

cosborn1231's method worked for me. Thanks for the help guys!

  • cosborn1231's avatar
    cosborn1231
    Icon for Resolver I rankResolver I
    10 years ago

    Anonymous Anytime!