Sumarize what-if measure

[helioandrade]

hello,

i'm need summarized this sample

table_whatif.values_1

dim_table_1.column_a

dim_table_2.columns_b

dim_table_3.columns_c

fact_table_4.columns_d

measure1(fact_table_4[columns_d] * table_whatif[values_1]

it's possible?

 summarize(

    dim_table_1.column_a,

    dim_table_2.columns_b,

    dim_table_3.columns_c,

    measure1(fact_table_4[columns_d] * table_whatif[values_1])

[v-jingzhang]

Hi @helioandrade 

Can you provide some sample data (dummy data) and expected result to help us understand your requirement better, as well as the measures used in [VOLUME 2020 COM % CRESC]?

Maybe you can try SUMMARIZECOLUMNS function (DAX). It doesn't need a base table. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[amitchandak]

@helioandrade , You can have like

summarize(fact_table_4, //table  join with all dim

dim_table_1.column_a,

dim_table_2.columns_b,

dim_table_3.columns_c,

"_Measure", sum(fact_table_4[columns_d]) * Sum(table_whatif[values_1])

)

[helioandrade]

tks for helping,
but this not work

i'm try this:

Tabela2 = SUMMARIZE(base,FAIXA[FAIXA PRECO],TD_SEGMENTO_MERCADO[SEGMENTO DE MERCADO],TD_CATEGORIA[CATEGORIA],"volume", [VOLUME 2020 COM % CRESC])