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

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