Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
blockobito
Helper I
Helper I

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

10 REPLIES 10
Chew_WenJie
Resolver II
Resolver II

Hi,

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

 

Hope this can helps you.

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

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

 

Chew_WenJie_0-1669692820759.png

Or

Chew_WenJie_1-1669692854157.png

Hope this can help you.

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

blockobito_0-1669693137495.png

 

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
Super User
Super User

could you pls provide the sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




blockobito_0-1669691147414.png

Sorry i have to create it via excel. 

 

I created something like that in Data Model. 

 

what's the expected output?

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




blockobito_0-1669693548439.png

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. 

 

could you pls provide the pbix file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.