How not to count or summarize a value?

[blockobito]

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 you~ 

[Chew_WenJie]

Hi,

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

Hope this can helps you.

[blockobito]

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

[Chew_WenJie]

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

Or

Hope this can help you.

[blockobito]

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

[ghaines]

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?

[ryan_mayu]

could you pls provide the sample data and expected output?

[blockobito]

Sorry i have to create it via excel. 

I created something like that in Data Model. 

[ryan_mayu]

what's the expected output?

i think you need to provide one sample data screenshot and one output screenshot.

[blockobito]

this is one of the result that i got but without the Don't Summarize. I tried it on the Table but it doesnt work. it still counts the data even on the text form. 

[ryan_mayu]

could you pls provide the pbix file?