Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello , i am facing problem , when i add a numiric field it keeps getting the count , and i dont want to show the count so how do i fix ?
Solved! Go to Solution.
Did you check the column's default summarization property?
Go to the Data view and make sure default summarization is set to "Do Not Summarize".
Hope this helps!
Did you check the column's default summarization property?
Go to the Data view and make sure default summarization is set to "Do Not Summarize".
Hope this helps!
example of my data ,
domain names i have owned , running ports , fixed ip and last field is count ( agrigated sumurized )
problem is it counts uses ports
Has this column been explicitely formatted as number already?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
yes , and iv'e changed the type to text but still , it counts
Well - then it behaves as it should:
A measure (as opposed to a field from a column) will always show some sort of aggregation. If it is formatted as numeric it will default to SUM, but if it is formatted as text, it will default to COUNT.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |