Aggr and rank function from qlik to power bi

[Giada_Togliatti]

Hi,

I need to traslate this formula from qlik to power bi

aggr(rank(sum([field1),1,1), [field2], [field3])

Aggr function in qlik has this meaning: aggr() returns an array of values for the expression calculated over the stated dimension or dimensions. For example, the maximum value of sales, per customer, per region. 

Could anyone help me?

Thank you

[Eugene_poddany]

Hi everyone.

Try this function:

Column 2 = calculate(SUMX('TableName',TableName[Column1] + TableName[Column2]))

or join with next function

My_column = SUMX( FILTER( 'TableName',TableName[Column1] <> "NULL"), TableName[Column1] + TableName[Column2] )

[_MR_DTT_]

Hello Giada,

I have the same problem as you, and I still can't find a solution.

Have you managed to find one?

Greetings

[Giada_Togliatti]

Hello,

unfortunately no.

Greetings

[jimmygdsis]

Email me at jimmy@gdsis.cl we specialize in both technologies, we can help you.

[Icey]

Hi @Giada_Togliatti ,

I don't understand your qilk language. Can you give me a specific example to help me understand?

Please show me some sample data and the result you want.

Best Regards,

Icey

[amitchandak]

@Giada_Togliatti ,

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

example

City Rank = RANKX(all(Geography[City]),[Sales]) // if you  add city id ither then city then rank will be one
Geography Rank = RANKX(all(Geography),[Sales]) // both for city id and city it will work
City and ID Rank = RANKX(all(Geography[City],Geography[City Id]),[Sales]) // work for city and city id as both are the lowset level

[Mariusz]

Hi @Giada_Togliatti 

Can you provide some data samples and explain what you need? Happy to help but no idea about qlik.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn