topic Re: Multi-row Aggregations in DAX in DAX Commands and Tips

Multi-row Aggregations in DAX

jrivera43 — Sun, 16 May 2021 00:22:07 GMT

Does anyone know how to create multi-row aggregations like this in DAX? I need to get a subcategory under the main category like the image below. I need to create a virtual table first to create a measure from. Any help would be appreciated.

Re: Multi-row Aggregations in DAX

Jihwan_Kim — Sun, 16 May 2021 04:53:14 GMT

Hi, jrivera43

I do not know well how your data model looks like. But I tried to create the below sample pbix file based on the explanation.

I suggest having dim table like below.

please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

https://www.dropbox.com/s/pkq9eo4oral5wei/jrivera.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Re: Multi-row Aggregations in DAX

jrivera43 — Mon, 17 May 2021 01:27:37 GMT

Thanks Jiwan,

Can you show me what the DAX would look like to create a virtual table using the same structure as the ones shown?

Re: Multi-row Aggregations in DAX

Jihwan_Kim — Mon, 17 May 2021 03:15:10 GMT

Hi, jrivera43

Thank you for your feedback.

Sorry that I quite do not understand your question.

Do you want to write an incomplete measure? And may I ask what is it for?

Re: Multi-row Aggregations in DAX

jrivera43 — Mon, 17 May 2021 12:25:04 GMT

I would like to create a flag measure. The flag measure needs to show whether the calculation is over or under a certain amount. Using something similar to the example:

Ultimately I want to get to this: