topic Re: Dax to exclude min value from power bi report in DAX Commands and Tips

Dax to exclude min value from power bi report

Learnpbifab — Sat, 15 Mar 2025 02:46:31 GMT

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

Re: Dax to exclude min value from power bi report

Jihwan_Kim — Sat, 15 Mar 2025 08:58:22 GMT

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 )

Re: Dax to exclude min value from power bi report

Hakuna_matata — Sat, 15 Mar 2025 09:00:14 GMT

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!!

Re: Dax to exclude min value from power bi report

techies — Sat, 15 Mar 2025 19:19:46 GMT

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() )

Re: Dax to exclude min value from power bi report

Anonymous — Mon, 17 Mar 2025 02:45:11 GMT

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

Re: Dax to exclude min value from power bi report

Anonymous — Fri, 21 Mar 2025 07:20:33 GMT

HI Learnpbifab,

Any update on this? Did these suggestion helps?

Regards,

Xiaoxin Sheng

Re: Dax to exclude min value from power bi report

v-kpoloju-msft — Tue, 22 Apr 2025 14:49:31 GMT

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!

Re: Dax to exclude min value from power bi report

v-kpoloju-msft — Mon, 28 Apr 2025 06:48:53 GMT

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.

Re: Dax to exclude min value from power bi report

v-kpoloju-msft — Thu, 01 May 2025 05:07:28 GMT

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.