topic Re: custom smart narrative for percent of total in DAX Commands and Tips

custom smart narrative for percent of total

EAPCGF — Thu, 10 Oct 2024 16:19:24 GMT

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

Re: custom smart narrative for percent of total

lbendlin — Thu, 10 Oct 2024 17:43:20 GMT

Can you share sample data that covers the scenario?

Re: custom smart narrative for percent of total

EAPCGF — Fri, 11 Oct 2024 00:42:36 GMT

Thank you, I cant see how to attach a file but here is a screen shot of some dummy data

Re: custom smart narrative for percent of total

lbendlin — Fri, 11 Oct 2024 01:22:05 GMT

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Re: custom smart narrative for percent of total

EAPCGF — Fri, 11 Oct 2024 01:56:06 GMT

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

Re: custom smart narrative for percent of total

EAPCGF — Fri, 11 Oct 2024 02:21:18 GMT

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

Re: custom smart narrative for percent of total

lbendlin — Fri, 11 Oct 2024 13:02:10 GMT

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.

Re: custom smart narrative for percent of total

EAPCGF — Tue, 15 Oct 2024 02:54:24 GMT

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

Re: custom smart narrative for percent of total

Irwan — Tue, 15 Oct 2024 03:27:46 GMT

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.

Re: custom smart narrative for percent of total

Anonymous — Tue, 15 Oct 2024 03:48:40 GMT

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

Re: custom smart narrative for percent of total

EAPCGF — Wed, 23 Oct 2024 23:16:44 GMT

Hi Bof, that's great, thank you very much 😃