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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

PowerBI Q&A Default Value

Hi all,


I am using Natural Language on Power BI (Q&A functionality).


When I ask a question, i.e. Top 5 products by customers.


The default value it's returning me is the SUM of duration, instead of the COUNT of Product ID.


For context, I have a duration field (for shipping duration) and a Product ID field.


Do you know how I can edit the Linguistic Schema / Dataset to make it understand to pick up COUNT of Product ID instead of SUM of duration?


This is consistent across any question that I ask, where I don't specify total duration or count of products.

Community Support
Community Support

Hi, @xPBIExplorer 


Based on your description, I wrote this statement to fulfill your requirement: Top 5 products of tables by total customer number. Following picture shows the effect of the display.



Best Regards,
Community Support Team


If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum



Super User
Super User

Hello @xPBIExplorer ,


you need to include in your question that you want the count.


check this out


Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.