Forum Discussion
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
- Idrissshatila
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
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,
Yang
Community Support TeamIf 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
