Forum Discussion

lafakios's avatar
lafakios
Helper I
3 years ago
Solved

Create calculated table with filtered distinct rows

Hi,   I want to create a calculated table based on a dimension table. The dimension table has several rows and some of the rows share the same value in the first column.     In the calculated ta...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi lafakios 

    It doesn't look like a use case of GENERATE. Simply use

    NewTable =
    SUMMARIZE (
    FILTER ( 'DimensionTable', 'DimensionTable'[IsActive] = "True" ),
    'DimensionTable'[FirstColumn],
    "Count", COUNT ( 'DimensionTable'[SecondColumnn] )
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi lafakios 

It doesn't look like a use case of GENERATE. Simply use

NewTable =
SUMMARIZE (
FILTER ( 'DimensionTable', 'DimensionTable'[IsActive] = "True" ),
'DimensionTable'[FirstColumn],
"Count", COUNT ( 'DimensionTable'[SecondColumnn] )
)

lafakios's avatar
lafakios
Helper I
3 years ago

This worked, thanks a lot for your help!