Forum Discussion

Sub's avatar
Sub
Regular Visitor
9 years ago
Solved

How do I get this expression to work?

I have no idea if this is the correct place for placing this question. If it's not, please, feel free to change it. It concerns the following expression:   Meldingen = SUMMARIZE (     'powerbi v...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Sub,

     

    I think you forget to write the measure name, right?

     

    Sample:

     

    Column/Measure Name= SUMX(SUMMARIZE
(
    'powerbi vgb_melding';
    'powerbi vgb_melding'[aanvangdatum];
    "Meldingen"; SUM('powerbi vgb_melding'[aangemaaktid] )
),[Meldingen])

     

    Regards,

    Xiaoxin Sheng

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Are you creating a table because SUMMARIZE will return a table. If you are trying to create a measure with that formula it will fail because you are trying to shove a table into a scalar.