Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Prevent spliting when using LYTD (pbix attached)

I can't make the below behaviour:

pbix here: https://drive.google.com/file/d/1tpGKvL_ST1L7YgDkDFqqLqfKb0FEjfcL/view?usp=sharing

 

 

 

 

I have a single selection filter on Year, and when I select 2021:

 

 

My goal is to never split a Customer on Type, so, when I show the totals, I want to see: Net Revenue LYTD as 54 but in Locale, not in Inter:

 

That is, I want to: when using Net Revenue LYTD, to display it in the same Type as the type in 'Net Revenue YTD'.

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , for that you need to have column that merge these two

    New type = if([Type] in {"Inter", "Locale"} ,"Locale", [Type]) 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your answer, but it is dynamic... It can happen with more than one client in the future (or different type names)

      (The only good thing is: that if they switch, they do it on 01-Jan).

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi， Anonymous 

        I'm not sure what you mean by ‘dynamic’.

        Why not consider using the field 'Customer' in table visual directly?

        In addition to manually creating a calculated column as mentioned by amitchandak , you can also try to right-click the field, and select New group from the menu.

         

        Result will show as follows:

        Best Regards,
        Community Support Team _ Eason