Forum Discussion

jrivera43's avatar
jrivera43
Frequent Visitor
5 years ago

Multi-row Aggregations in DAX

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 me...
jrivera43's avatar
jrivera43
Frequent Visitor
5 years ago

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?

 

 

 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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?

  • jrivera43's avatar
    jrivera43
    Frequent Visitor
    5 years ago

    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: