Forum Discussion

michaeljc70's avatar
michaeljc70
Icon for Advocate II rankAdvocate II
10 years ago

Make a column not sum/count

I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations.  I am still fairly new to this though and cannot figure this out.    I imported a ...
Need Help
v-esdev's avatar
v-esdev
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi All,

 

I am also facing same issue. does anyone find solution for this.

 

Please help me on this.

 

Thanks,

Eswar

AWeichselbaum's avatar
AWeichselbaum
Icon for Advocate I rankAdvocate I
9 years ago

I just figured this out.

 

Under Fields, click on the field which is being auto-summarized. Once selected, go to the top ribbon and click "modeling". You will then see a button called "Default Summarization..." click this, and select 'do not summarize'. Above that button you can also change what the data is - this is useful for telling Power BI that the data is a postal zip code, for instance.

  • RBilton's avatar
    RBilton
    New Member
    9 years ago

    Perfect!  That was the answer.   Thanks so much for posting. Your answer keeps on giving!

  • smemusi's avatar
    smemusi
    New Member
    6 years ago

    I can't see that option. Please help

    • natabird3's avatar
      natabird3
      Icon for Skilled Sharer rankSkilled Sharer
      6 years ago

      smemusi 

      You should try selecting the value that you need in the fields column, after which in the top menu select the summarization that you desire (dont summ for isntance). and it should solve your problem, hoep this helps.