Skip to main content
cancel
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.

Reply
xPBIExplorer
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.

2 REPLIES 2
v-yaningy-msft
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.

 

vyaningymsft_0-1708592308866.png


Best Regards,
Yang
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

 

 

Idrissshatila
Super User
Super User

Hello @xPBIExplorer ,

 

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

 

check this out https://youtu.be/2S6qVQrmzxE?si=Dy5E-sUHLWemlIW7

 



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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.