Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Calculation Group with Tabular Editor

Alexgamb20_0-1642999065537.png

Using calculation group with Tabular Editor, when selecting the segmenter whether this volume, sales or contributions show the 3 data that correspond to CY: As current year PY: as last year and BG as Budget with its corresponding unit of measurement for example if it is contributions show me only the contributions 2021, 2022, and the respective Budget in a graph as shown above. 2021 and 2020 go in bars and the budget the line... the attached tables are an example of my model I have attached the 2 years 2021 and 2020 in a single table.

If the graph could not be made even if it is the segmentation with the 3 measures with their format of unit of measurement.

I attach link with PBIX and BD in case someone would like to help me 😞

https://drive.google.com/drive/folders/1sbxfXNHW_FIYyP3-M4E7RQofGqwsRxVA?usp=sharing

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Alexgamb20,

    I updated your sample pbix file(see attachment), please check whether that is what you want.

    1. Update the formula of measure [BG BUdget] and [CY Current Year] as below

    BG BUdget = 
VAR _seldate =
    SELECTEDVALUE ( 'Fecha'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Year_BG_Key_Account'[Ventas USD] ),
        FILTER ( 'Year_BG_Key_Account', 'Year_BG_Key_Account'[Fecha] = _seldate )
    )
    CY Current Year = 
VAR _seldate =
    SELECTEDVALUE ( 'Fecha'[Date] )
RETURN
    CALCULATE (
        SUM ( Anexar1[Ventas USD] ),
        FILTER ( 'Anexar1', 'Anexar1'[Fecha] = _seldate )
    )

    2. Create a line and clustered column chart as below

    Best Regards

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    The problem is that you do not use tabular editor, to be able to change one measure with another and that has the corresponding format.