Aggregating text values from rows

Question

I have 3 tabels.&nbsp;Table 1 contains a series of Policy numersTable 2 Each Policy has 1 or more line items, which represent a coverage. They are represented by a TypeNrTable 3. Each coverage (TypeNr) is either a saving of risc.&nbsp;What I need, is a column is table 1, which shows if the policy only have items of the type Saving, Risc og Both. Any help will be greatly appreciated&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

jihwan_kim · Accepted Answer

Hi,
I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.
It is for creating a new table.
&nbsp;

&nbsp;

&nbsp;
Expected result new table =
VAR _t =
    SUMMARIZE ( Policy_Type, Policy[Policy], 'Type'[Type] )
VAR _condition =
    ADDCOLUMNS (
        _t,
        "@Coverage",
            IF (
                COUNTROWS ( FILTER ( _t, Policy[Policy] = EARLIER ( Policy[Policy] ) ) ) &gt; 1,
                "Both",
                'Type'[Type]
            )
    )
RETURN
    SUMMARIZE ( _condition, Policy[Policy], [@Coverage] )

&nbsp;
&nbsp;

Forum Discussion

Aggregating text values from rows

2 Replies

Related content

Text slicer: pasting multiple values

Dynamic values in text box

Data Aggregation issue

Snowflake connector: "We cannot convert the value null to type Text"

Month over Month with multiple text values