custom smart narrative for percent of total

[EAPCGF]

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

[v-bofeng-msft · Accepted solution]

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

[EAPCGF]

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

[EAPCGF]

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

[lbendlin]

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.

[EAPCGF]

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

[Irwan]

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.

[EAPCGF]

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

[lbendlin]

Can you share sample data that covers the scenario?

[EAPCGF]

Hi

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

[lbendlin]

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