Measure to calculate percentage of Low spend

[st-dat]

Hello Team,

Kindly help solve this issue explained below:

I have used below measure and others but could not get expected result…….

% Low Invoice = CALCULATE(DISTINCTCOUNT(Table1[Invoice]), FILTER(Table1, Table1[Net Sales]>15 && Table1[Net Sales]<40))

What is the percentage of invoice greater 15 pounds and less than 30 pounds?
Invoice	Item Type	Pounds
787878	10	5.00
787878	100	5.00
787878	5	5.00
787878	30	5.00
555566	50	10.00
555566	70	20.00
555566	5	20.00
555566	5	20.00
444499	20	10.00
444499	10	20.00
444499	200	20.00
666634	150	5.00
666634	30	10.00
666634	10	10.00
888222	30	50.00
888222	20	10.00
SOLUTION:
Total Invoice = DistinctCount of Invoice = 4
Range to consider - >15 and <30
787878 Invoice = 20 pounds within range
555555 invoice = 70 pounds within range
444499 Invoice = 50 pounds exceeds specified range
666634 Invoice = 25 pounds exceeds specified range
666634 Invoice = 60 pounds exceeds specified range
Two invoices within the range and Three exceeed the range = 2/5*100 = 40%

[Anonymous]

Hi st-dat,
See images I've attached.
Tell us if works for you.

[st-dat]

Hi,

Thank you so much, It works for general purpose and yet for my specific need. I will appreciate a measure that returns a single value for week and previous week sales.

Regards

St-dat

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=COUNTROWS(FILTER(SUMMARIZE(VALUES(Data[Invoice]),[Invoice],"ABCD",SUM(Data[Pounds])),[ABCD]>=15&&[ABCD]<=30))/DISTINCTCOUNT(Data[Invoice])

Hope this helps.

[st-dat]

Hi, Thank you, I will be able to test and provide feedback on Monday.

Just to confirm again, what is rquire to do are: (1) find distinct count value of invoice with

cummulative total between 15 and 30 pounds divide by (2) distinct count of all the invoices.

I trust your judgement always, I have one more request posted.

Best regards

[v-cherch-msft]

Hi  @st-dat

Do you have any other problems? If not, please accept the helpful reply as solution, that way, other community members will easily find the solution when they get same issue.

Regards,

Cherie

[st-dat]

Hi Cherie,

I just did, thanks

Regards

St-dat