Forum Discussion

ugux's avatar
ugux
Frequent Visitor
5 years ago
Solved

Grouping data based on two level conditions

I have a Data modell, which works fine. Data table, Customers, products, dates…etc…Now I got a special request They want to see a new kind of grouping, which have 2 levels. 1st - not all of custome...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, ugux 

    Thank you for sharing.

    Please check the link down below.

    It seems working. However, I am not quite convinced to myself whether it is the best solution or the worst solution. Because the measure is using Treatas function two times in the same measure.

    Please check whether it suits your real model.

     

    https://www.dropbox.com/s/vaf19ug4l029g17/ugux_v2.pbix?dl=0 

    Thank you.

     

    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

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, ugux 

Thank you for sharing.

Please check the link down below.

It seems working. However, I am not quite convinced to myself whether it is the best solution or the worst solution. Because the measure is using Treatas function two times in the same measure.

Please check whether it suits your real model.

 

https://www.dropbox.com/s/vaf19ug4l029g17/ugux_v2.pbix?dl=0 

Thank you.

 

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

ugux's avatar
ugux
Frequent Visitor
5 years ago

Hi Kim,

 

It's fantastic, so simple in 1 row measure 🙂 and working. Now I must learn what treatas doing exactly.

Thank you so much.

 

Have a nice day