Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Icon for Post Patron rankPost Patron
6 years ago
Solved

MAXX Threshold Value

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

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

3 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    6 years ago

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

    • Ritesh_Air's avatar
      Ritesh_Air
      Icon for Post Patron rankPost Patron
      6 years ago

      Stachu 

       

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

       

      thanks,

      Ritesh

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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