Craziest Set Analysis Yet (Only Experts)

[Mario_ES]

Hello,

I'm trying to filter lines of a table that has multiple dimensions and only one expression that I use for filtering.

The field's values are something like this:

And the end product has to be something like this: 

I believe that the correct expressión is this one:

Count ( Distinct {<form_order={"max(<[No. Proceso]>form_order)"}>} [No. Proceso])

Do you have any idea why this isn't working?

Thanks!

[MatheusC]

Maybe this:

For your form_order dimension form_order :

=AGGR(max(form_order), [No.Proceso])

to your measure:

=count(Aggr(FirstSortedValue([No.Proceso],-form_order),[No.Proceso]))

Regarts, Matheus

[marcus_sommer]

Your max-condition isn't evaluated else taken as a search-string. Therefore try it in this way:

Count ( Distinct {<form_order={"$(=max(<[No. Proceso]>form_order))"}>} [No. Proceso])

[Mario_ES]

Thank you very much for your answer.

I think that it shouldn't be evaluated.

Look at the screenshot:

In the dialog, you can see that it doesn't find the max form_order because there are many No. Proceso at the same time.

With this formula, I get no results even though I haven't filtered the information on any field:

You can try it in your QS if you want.

[TauseefKhan]

Hi @Mario_ES,

Result:

form_order =
Count( Distinct {<form_order={"=max({<No_Procesol= >} form_order)"} >} form_order)

Count =
Count( Distinct {<form_order={"=max({<No_Procesol={$(=max(No_Procesol))}>} form_order)"}>} No_Procesol)

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.

[BrunPierre]

As below.

Count(DISTINCT If(form_order=Aggr(Max(TOTAL<[No. Proceso]>form_order), form_order, [No. Proceso]), [No. Proceso]))