- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
custom smart narrative for percent of total
Hi I have a viz with 2 categories and a count of patients in each category. I also have a matrix table showing same.
I need a smart narrative that tells me the percent in each category.
We don't have access to copilot.
When I right click, "summarise" the viz, the summary tells me the count of the highest category as a percent of total, but not the percent of total of the other (lower) category.
When I creat a new value in smart narrative, I can get the count by typing count of (category) easily, but I can't get a percent of total.
I can't get it to recognize/replicate the 'summary' text which says 'as a % of total'
In my matrix table I added a column with DAX formula for calculating percent of total for each category. In the matrix table the percent of total is correct, but when I try to get the smar narrative to tell me percent of total for each category, it just shows 100%, not the percent of each of the two categories.
What language do I use for the smart narrative? or what other DAX to I need?
screen shots.
Thanks
what summary does
what i tried
what i tried also
DAX for percent measure
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @EAPCGF ,
I've made a test for your refrence:
1\I assume there is a table(Table)
2\Add a caculate column
Percent Stream2 = CALCULATE(COUNTROWS('Table'),Filter('Table',EARLIER('Table'[65 or older])='Table'[65 or older]))/COUNTROWS('Table')
3\Set the visual
Best Regards,
Bof
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @EAPCGF ,
I've made a test for your refrence:
1\I assume there is a table(Table)
2\Add a caculate column
Percent Stream2 = CALCULATE(COUNTROWS('Table'),Filter('Table',EARLIER('Table'[65 or older])='Table'[65 or older]))/COUNTROWS('Table')
3\Set the visual
Best Regards,
Bof
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Bof, that's great, thank you very much 😃
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ID | 65 or older |
1 | Under 65 |
2 | Under 65 |
3 | Under 65 |
4 | Under 65 |
5 | 65 or Over |
6 | Under 65 |
7 | 65 or Over |
8 | Under 65 |
9 | Under 65 |
10 | Under 65 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I played around with this a bit but haven't gotten it to work yet. Will try a few more things, but maybe someone else with more expertise on smart narratives can chime in.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for trying, can anyone recommend a way to bump this question or post it somewhere else? Even if the answer is that there is no solution it would be good to know. thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello @EAPCGF
i assumed you want to get the result based on the description in Calculate box in smart narratives.
have you tried to write exact same sentence as the auto generated in your custom narratives?
Also, i got the same problem in my project and couldnt figure out how or why.
in my case, even if i wrote the exact same description as auto generated, it still will not show same result as auto generated showed.
so for me, i created a new measure only for this narratives. here is the example using your sample data.
so in Calculate box, i just put the measure inside.
and yes, it is kinda redundant measure only to be used for one narrative.
Hope this will help.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ID | 65 or older |
1 | Under 65 |
2 | Under 65 |
3 | Under 65 |
4 | Under 65 |
5 | 65 or Over |
6 | Under 65 |
7 | 65 or Over |
8 | Under 65 |
9 | Under 65 |
10 | Under 65 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share sample data that covers the scenario?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Thank you, I cant see how to attach a file but here is a screen shot of some dummy data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-14-2024 02:46 AM | |||
12-09-2024 03:56 AM | |||
06-13-2022 02:23 PM | |||
02-07-2024 02:53 AM | |||
02-20-2022 09:14 AM |
User | Count |
---|---|
14 | |
13 | |
10 | |
10 | |
8 |
User | Count |
---|---|
19 | |
17 | |
14 | |
13 | |
11 |