Forum Discussion

helioandrade's avatar
helioandrade
New Member
4 years ago

Sumarize what-if measure

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])

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      helioandrade
      New Member
      4 years ago

      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])
  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.