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 mo...
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

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