Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Disconnected/Summary Table

Hi all, I wish to create a small summary table that gives my users a bit more information with key metrics on a table. Ideally, I only have one slicer with years 2021,2022 etc.  How can I create a...
  • Dhacd's avatar
    Dhacd
    4 years ago

    Hi Anonymous ,

    I can provide you with a direction.
    Create measures for all the categories you have mentioned. 
    Eg: MeasureTotalsales = sum(table[Total Sales])
    MeasureTotal Orders to date = Sum(Total Orders) and so on....

    And create a switch like below.
    Switch('categorytable'[Categories] ,
           "Total Sales",MeasureTotalsales,
            "Total Orders to date",MeasureTotal Orders to date,
                                             .
                                              .

    till the last table.
    Then use the category column from the category table inside of a table and add the switch measure as another column. Make sure that the category table and the fact table have no relationship.

    Reply if you face any issues.

    If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
    Regards,
    Atma.

Dhacd's avatar
Dhacd
Icon for Resolver III rankResolver III
4 years ago

Hi Anonymous ,

I can provide you with a direction.
Create measures for all the categories you have mentioned. 
Eg: MeasureTotalsales = sum(table[Total Sales])
MeasureTotal Orders to date = Sum(Total Orders) and so on....

And create a switch like below.
Switch('categorytable'[Categories] ,
       "Total Sales",MeasureTotalsales,
        "Total Orders to date",MeasureTotal Orders to date,
                                         .
                                          .

till the last table.
Then use the category column from the category table inside of a table and add the switch measure as another column. Make sure that the category table and the fact table have no relationship.

Reply if you face any issues.

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Regards,
Atma.