Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
10 years ago
Solved

Default Summarization

I'm having issues with the default summarization control in Power BI Destkop. For some reason, its inactive and I can't change it from 'Do Not Summarize' and I think its why my measures, that have th...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Caitlin_Knox - Perhaps a data type issue with your calculated column? Generally that would return an error though in a measure, for example trying to SUM a text column. Grasping at straws here.

     

    What if you try an equivalent measure without the column:

     

    Sum2 of S2473 - 00201 = SUMX(FILTER(tbl_FixedCost,[Client_Code]="S2473" && [ACCT]="00201"),[Quan​tity_Enrolled])

     

    Technically probably a better way to do what you are doing since it avoids the extraneous calculated column and all of the logic is contained within the filter. Essentially what this is doing is returning a table filtered down to just the Client_Code and ACCT that you want and then summing Quantity_Enrolled for only those rows. Should be 100% equivalent to your method. Just curious about whether eliminating that calculated column does anything.

ifat_c's avatar
ifat_c
Helper I
7 years ago

Hi 

I'm trying to build a report using the power BI desktop, my dataset it from: power Bi -> power BI datasets

it's a push dataset.

and a lot of options are grey for me using this dataset: modeling, adding columns.

the only thing enabled in modeling is a new measure button. 

therefor i can't change the default summarization to any field (not a measure! a field in the dataset!)

please help

thanks