DAX support

v-yuta-msft

my requirement is to get the below view, is it possible? this is basically a waterfall chart in PPT

Now coming back to your question.

the ranking measures you have shared is actually not grouping the similar accounts into one and ranking it.

it means there are multiple lines for an account with TER_FYTD_USD values, apparently this multiple lines should club and become one single account and TER_FYTD_USD Value, eventually it should rank accordingly. In simple words PIVOT of the data which combines muliple lines into one.

My opinion is that the below view can be achieved only if we create a calculate coloumn instead of measure.

this is how calculated coloumn should be created

1) if accounts are G360, we don't have to rank it, keep the calculated coloumn as G360                                 

2) if an accounts are Core, Club the similar accounts                                     ( eg ABC account    core segment,   TER 2000

                                                                                                               ABC account    core segment,   TER  2500

                                                                                                  Output  ABC account    core segment     TER 4500

then rank it &  Identiy those top 10 core accounts based on TER_FYTD values & keep the calculated coloumn as TOP 10 Core account

3)  if accounts are Core, Club the account                                     ( eg ABC account    core segment,   TER 2000

                                                                                                               ABC account    core segment,   TER  2500

                                                                                                  Output  ABC account    core segment     TER 4500

then rank it &  Identiy those Next 15 core accounts based on TER_FYTD values & keep the calculated coloumn as Next 15 Core account

4)  if an account is Core, Club the account                                     ( eg ABC account    core segment,   TER 2000

                                                                                                               ABC account    core segment,   TER  2500

                                                                                                  Output  ABC account    core segment     TER 4500

then rank it &  Identiy those Remainder core accounts based on TER_FYTD values & keep the calculated coloumn as Remainder Core account

is it possible to create a caculated coloumn to achieve the below view?