Forum Discussion

dannyh246's avatar
dannyh246
Regular Visitor
8 years ago

Multiple Grouping & Sorting With Slicer

I have a fact table called FactAccumulation, which contains appox 500million records. I have a dimension table called dimZone with about 50 records.    Both are defined as follows.      [FactAc...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi dannyh246,

 

Please check out the demo here. 

1. Create a calculated table as MiddleTable.

MiddleTable =
SUMMARIZE (
    'FactAccumulation',
    DimZone[Zone Key],
    FactAccumulation[Event ID],
    FactAccumulation[Year],
    "Total", SUM ( FactAccumulation[Loss USD] )
)

2. Create a measure for row numbers.

RowNumEqually =
RANKX (
    ALL ( 'MiddleTable'[Year] ),
    CALCULATE ( MAX ( 'MiddleTable'[Total] ) )
)

3. Create a table visual. The choose calculation type Maximum for column "Total".

Multiple_Grouping_Sorting_With_Slicer

 

 

Best Regards,

Dale