MAXX Threshold Value

[Ritesh_Air]

Hi experts,

Update:  I updated the file. Reduced its size by 90%.

Wanted to see if I can find a particular value based on a condition.

I tried to use Minx function but have no clue how to move forward. Attached is the pbix.

Problem statement:

1. I am looking for the threshold value when I reach 80% of the total sale. for e.g, the one highlighted in yellow then I want to show that in a card. I want to show $25,405 in a card.
2. And the number at which it occurred, in this case, it was 193. Which mean there are 193 customers which are core customers.

Any help is appreciated.

https://drive.google.com/file/d/1Rh8LUGseeidYTaud_T-GfoGsvpgb7zEx/view?usp=sharing

Thanks,

Ritesh

[v-shex-msft · Accepted solution]

HI @Ritesh_Air,

You can try to use the following measure formulas to get the max sale and the row counts of a specific range based on the target.

Target=0.8

MAX Sales =
    CALCULATE (
        MAX ( 'Table'[Sales] ),
        FILTER ( ALLSELECTED ( 'Table' ), ROUNDDOWN ( [Rate], 2 ) = [Target])
    )

Row counts =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( ALLSELECTED ( 'Table' ), ROUNDDOWN ( [Rate], 2 ) = [Target] )
)

If above not helps, please share some dummy data to test. (your sample file seems expired so I can't access it)
Regards,

Xiaoxin Sheng

[Stachu]

What determines the order in which the sum is acumulated? Alphabetical, date of transaction, value of the transaction, random?

[Ritesh_Air]

@Stachu 

The sum is accumulated in desc order of sales amount. If you sold the most, you are at the top.

thanks,

Ritesh