Forum Discussion
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). ...
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.
cosborn1231's method worked for me. Thanks for the help guys!
cosborn1231
Resolver I
Resolver IAnonymous Anytime!