Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation

helloworld_ — Fri, 15 Dec 2023 09:39:30 GMT

I have to generate a paginated report for a matrix table. I've created dummy data as follows:

Table A (storing different hierarchies of fields):

Table B (storing comments in concatenated format):

The DAX formula I used to allow comments to be shown at specific level:

comments_measure = CALCULATE( MAX(comments[comments]), FILTER( comments, comments[selected] = SELECTEDVALUE('fact'[Alphabet])&SELECTEDVALUE('fact'[Food]) ))

The results in Power BI looks like this:

However when I imported the same measure in Report Builder and created the matrix visual, I get the following results:

The comments for Level 1 (Alphabet) are not being reflected correctly.

Any idea to get this working correctly?

Re: Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation

trivedisunita — Wed, 24 Jun 2026 09:47:24 GMT

Hi helloworld_

SELECTEDVALUE works nicely inside Power BI visuals because each cell has a clear filter context. But when you bring the same measure into Report Builder, the matrix doesn’t pass that context in the same way, so the Alphabet‑level comments don’t show up correctly.

A cleaner way is to build a key column in both tables (for example, Alphabet & Food) and then use that in your measure. Something like:

measure =
CALCULATE (
MAX ( comments[comments] ),
FILTER ( comments, comments[Key] = MAX ( fact[Key] ) )
)

This way, the measure doesn’t rely on SELECTEDVALUE but instead uses MAX, which works consistently in both Power BI and Paginated Reports. If you only want Alphabet‑level comments, you can make a separate measure that matches on Alphabet alone

alphabet =
CALCULATE (
MAX ( comments[comments] ),
FILTER ( comments, comments[Alphabet] = MAX ( fact[Alphabet] ) )
)

That should give you consistent results in Report Builder as well as Power BI

If this reply helped you please mark it as a solutions .

Thank you

Sunita

topic Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation in Report Server

Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation

Re: Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation