Split data

[RanjanThammaiah]

Hi All,

Can any one help me to split the data into rows without affecting the total Numbers.

why i need the UDN into rows because I need to create a row level security based on the UDN to give them the respective data access.

Let me know is there any better way of doing it.

The below are just the data samples.

[v-juanli-msft · Accepted solution]

Hi @RanjanThammaiah 

If you'd like this result, please refer to @Mariusz 's pbix.

If you'd like this, please refer to table "new1" and page2 in my pbix

Before spit columns into rows, add an exdex column,

then Create measures

single_value =
VAR count_ =
    CALCULATE (
        COUNT ( new1[UDN] ),
        FILTER ( ALLSELECTED ( new1 ), new1[Index] = MAX ( new1[Index] ) )
    )
RETURN
    SUM ( new1[VALUE] ) / count_

Measure 3 = IF(HASONEVALUE(new1[UDN]),SUM(new1[VALUE]),SUMX(ALLSELECTED(new1),[single_value]))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @RanjanThammaiah 

You can Create a Bridge table that filters Original Table or Split the Values, 

Please see both solutions on the attached file

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[tex628]

Follow these steps:

Starting table:


Split column 1 by delimiter ",":


Highlight all column except for the value, then press Unpivot Columns:


Should give you the following result:


Hope it helps,