Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

values displaying on different ROWS even after same country_ID, need them in same row, need help

I've 2 major columns ID and VALUE ,
VALUE columns holds all the values like price, quantity, date, yes/no.... many more

 

I created new columns

IncentiveScheme = IF(FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] in {216}, 'FACT_KPI_ENV'[VALUE], BLANK())
Device = IF(FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] in {752}, 'FACT_KPI_ENV'[VALUE], BLANK())
StartDate = IF(FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] in {2589}, 'FACT_KPI_ENV'[VALUE], BLANK())

and then changed the column type to suitable data_type

but when I created table , the values are not coming in same row instead displaying in different rows even for
same country_ID(a column from same table)

 

all 4 columns are from same table , values with same country_ID should come in same row, how can I do it please help, thanks

Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column =
IF (
    FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] IN { 216 },
    'FACT_KPI_ENV'[VALUE],
    IF (
        FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] IN { 752 },
        'FACT_KPI_ENV'[VALUE],
        IF (
            FACT_KPI_ENV[DIM_KPI_INDICATOR_ID] IN { 2589 },
            'FACT_KPI_ENV'[VALUE],
            BLANK ()
        )
    )
)

    Is this the result you expect? If not, simplify your data and give examples of your desired output. You can also show it with pictures or EXCEL.

     

    Best Regards,

    Community Support Team _Charlotte

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