Forum Discussion

blockobito's avatar
blockobito
Icon for Helper I rankHelper I
3 years ago

How not to count or summarize a value?

i need help with this visual.  I created a custom table with Values. i cannot seem tofind the option to not summarize the value or not to count i need the static number that i created.   Thank y...
Need Help
Chew_WenJie's avatar
Chew_WenJie
Icon for Resolver III rankResolver III
3 years ago

Hi,

You actually can change the values into text format, then it will not summarize anymore.

 

Hope this can helps you.

blockobito's avatar
blockobito
Icon for Helper I rankHelper I
3 years ago

When i tried changing it to text it still count the number Count( Distinct ) and Count 

  • Chew_WenJie's avatar
    Chew_WenJie
    Icon for Resolver III rankResolver III
    3 years ago

    That's weird. Have you try this method also?

     

    Or

    Hope this can help you.

    • blockobito's avatar
      blockobito
      Icon for Helper I rankHelper I
      3 years ago

      yes this the exactly the one that i made i tried doing that now but still i have no option for this one 

       

      • ghaines's avatar
        ghaines
        Icon for Resolver I rankResolver I
        3 years ago

        Hi,

         

        If your only options are Don't summarize, First, Last, Distinct and Count, then the value is not of a number type.  I'd suggest making sure that when the column is loaded from power query to the report, or the column is created in dax, that the column is of a number type, I think that will help you get a sense of what is actually happening even though it won't solve your problem directly.

         

        Agreed with what someone said before.  What is your data and what is your expected output?