Forum Discussion

EJones's avatar
EJones
Frequent Visitor
7 years ago

Measure Based on Finding Value from Dropdown within Text String

I'm not even sure where to begin with this one...I'll try to keep it as simple as possible.     We are trying to do a very basic market basket analysis.  For each of our POS orders, we are tracking...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi EJones,

 

Based on your descripition, I made a sample here. Could you please try to use the formulas as below to create measures?

 

Basket Transactions1 = COUNTROWS('POS Order Detail')
total = CALCULATE(COUNTROWS('POS Order Detail'),ALLSELECTED('POS Order Detail'))
% of total = DIVIDE([Basket Transactions1],[total])

The result for your reference.

For more details, please check the pbix as attached. If it doesn't meet your requirement, Could you please export your data to excel to me?

 

https://www.dropbox.com/s/abm80t01yy3sqlu/finding.pbix?dl=0

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi EJones,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,

    Frank