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
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?