Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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])
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.
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.
As below.
Count(DISTINCT If(form_order=Aggr(Max(TOTAL<[No. Proceso]>form_order), form_order, [No. Proceso]), [No. Proceso]))