Dax to exclude min value from power bi report

[Learnpbifab]

Hi all,

I have one report where I am showing value as processnum and processname.and i am trying to check all processnum under name excluding min value.

Dax:

Min=

Var a=min(table(processnum)

Return processnum > a

I am getting error when tried for above. Can anyone suggest

[v-kpoloju-msft]

Hi @Learnpbifab,

May i know has your issue been resolved? If the response provided by the @Jihwan_Kim, @Hakuna_matata, @techies addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @Learnpbifab,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @Learnpbifab,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

HI @Learnpbifab,

Any update on this? Did these suggestion helps?

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Learnpbifab ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[techies]

Hi @Learnpbifab please try this

ExcludeMinProcessNum =

VAR MinValue = CALCULATE(

    MIN('Sheet6'[processnum]),

    ALLEXCEPT('Sheet6', 'Sheet6'[processname])

)

RETURN

IF(SELECTEDVALUE('Sheet6'[processnum]) > MinValue, SELECTEDVALUE('Sheet6'[processnum]), BLANK() )

[Hakuna_matata]

Hi @Learnpbifab ,

The way you have applied Min will return the minimum processnum for the entire table, not for each specific processname.
Try the below measure:

Min_Excluded =
VAR MinValue = CALCULATE(MIN(Table[processnum]), ALLEXCEPT(Table, Table[processname]))
RETURN IF(Table[processnum] > MinValue, Table[processnum], BLANK())

Hope it helps!
If this solved your problem, please accept it as a solution!!

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

expected result measure: = 
VAR _processnumber =
    SUM ( data[process_number] )
VAR _min =
    MINX ( ALL ( data ), data[process_number] )
RETURN
    IF (
        _processnumber > _min
            && HASONEVALUE ( data[process_name] ),
        _processnumber
    )