rows split, but merging response results within table -- happy it repeats

[JK-1]

Is there a measure that would be able to perform the "overall" result in red, from the associated table data.

I would want it to be visual in the table, happy for the repeats, as having consolidated summary is useful when assessing.

thanks,

[Table]

Campaign	Number	Responded	View	campaign count	campaign&view	responded type count	view&responded type count	overall_show across all rows - merged result
10021	Rep1	15/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep2	18/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep3	21/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep4	21/05/2025	Disagreed	9	10021Disagreed	2	Disagreed 2	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep5	26/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep6	29/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep7	30/05/2025	Disagreed	9	10021Disagreed	2	Disagreed 2	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep8	30/05/2025	Incomplete	9	10021Incomplete	1	Incomplete 1	Agreed 6, Disagreed 2, Incomplete 1
10021	Rep9	30/05/2025	Agreed	9	10021Agreed	6	Agreed 6	Agreed 6, Disagreed 2, Incomplete 1
12524	Rep1	12/03/2025	Disagreed	1	12524Disagreed	1	Disagreed 1	Disagreed 1
9931	Rep1	25/01/2024	Agreed	2	9931Agreed	1	Agreed 1	Agreed 1, Incomplete 1
9931	Rep2	27/01/2024	Incomplete	2	9931Incomplete	1	Incomplete 1	Agreed 1, Incomplete 1

[maruthisp]

Hi JK-1 ,

Please find the below attached pbix file with a solution as per your original post.
rows split.pbix

Please let me know if you have any further questions or need clarifications.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[JK-1]

Thank you both. Its been very useful - have attempted to bring the number to the front instead but not been successful in re-writing this. Tried going through the steps and following the suggested prompts in DAX and struggling. If there's a prompt you can offer to guide on that would be great. Kind regards

@maruthisp @Nasif_Azam 

[JK-1]

I did find https://community.fabric.microsoft.com/t5/Developer/ConcatenateX-with-text-and-counts/m-p/1060149 but haven't yet cracked out the allexcept to be in the measure yet without erroring

[Nasif_Azam · Accepted solution]

Hey @JK-1 ,

Yes, you can create a measure in Power BI that replicates the behavior of the “overall_show across all rows merged result” column (in red) i.e., generating a consolidated summary of counts (Agreed, Disagreed, Incomplete) within the same campaign, and repeating it across all relevant rows for visual consistency.

Objective

You want a DAX measure that:

• Groups responses by type (Agreed, Disagreed, Incomplete) per Campaign

• Shows the aggregated count per type

• Repeats the result across each row of the campaign — not at the visual total level only

DAX Measure

Campaign Response Summary = 
VAR CurrentCampaign = SELECTEDVALUE('Table'[Campaign])
RETURN
CALCULATE (
    CONCATENATEX (
        VALUES('Table'[View]),
        'Table'[View] & " " & 
        CALCULATE(COUNTROWS('Table')),
        ", ",
        'Table'[View], 
        ASC
    ),
    ALLEXCEPT('Table', 'Table'[Campaign])
)

For Detailed Information:

Power BI: Repeating Aggregated Values in a Table Visual

DAX Patterns: Distinct Count per Group

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[JK-1]

The above has been very useful but am struggling to adapt it elsewhere. Should CONCAT work in the scenario below? There isn't a need for any count this time. Its just to bring the strings together from across 2 columns.

				{happy it purely groups or repeats - but it would be text rather than any counts}
Store	Level 1	Level 2
124	23 consents			23 consents // 13 calls
124		13 calls		23 consents // 13 calls
146	7 no-shows			7 no-shows // 6 accepted
146		6 accepted		7 no-shows // 6 accepted
159		14 declined		// 14 declined	{or  purely} 14 declined

[JK-1]

I did this as 2 separate measures and then just combined concat1 & concat2 but have lots of spare // throughout. Wanted to keep it within DAX though with a shorter method?

concat1 = concatenatex(filter(table,table[store]=earlier(table[store])),table[level 1], " // ",table[level 1],asc)

 .. repeat for level 2 then combined

thanks for original pointer via @hnguy71

[JK-1]

Thank you. Always amazed 👍