topic Re: rows split, but merging response results within table -- happy it repeats in DAX Commands and Tips

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

JK-1 — Sat, 14 Jun 2025 15:15:05 GMT

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

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

Nasif_Azam — Sat, 14 Jun 2025 16:05:39 GMT

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

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

maruthisp — Sun, 15 Jun 2025 11:19:21 GMT

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

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

JK-1 — Mon, 16 Jun 2025 11:14:41 GMT

Thank you. Always amazed 👍

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

JK-1 — Fri, 04 Jul 2025 19:56:54 GMT

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

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

JK-1 — Sat, 05 Jul 2025 15:39:02 GMT

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

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

JK-1 — Sat, 19 Jul 2025 12:03:43 GMT

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

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

JK-1 — Sun, 20 Jul 2025 08:27:45 GMT

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