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

[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]

Thank you. Always amazed 👍