Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
tone_radeu
Frequent Visitor

Default Value on empty Matrix Value

Greetings!

I Have this fairly large Dataset to work with, made plenty of visualizations, but I have been stumbling on this problem for a while now.
There is a page on my report that is a matrix, which basically shows engagement on this app, containing a selection of [Products] and its grouping [Copmponents], with the metrics being [Views], [Clicks] and [CTR], as shown as below.

tone_radeu_0-1705516192678.png

Problem is, that the View of these products have its own Click value, but not the view, since it they are grouped in a Carousel/Slideshow, so all of them technically share the same view, but different clicks. On the red arrow is the element containing the groupings.

Is there any way to default the empty values to the value of the groupings? I've tried separating them in a separate table, but id didn't work out...

tone_radeu_2-1705516783367.png

 

Unfortuantely, i can not share the report, since it has sobe sensitive data (had to censor some bits too), but any necessary input I can provide.

Does anyone have a clue on what to do in this scenario?




4 REPLIES 4
vanessafvg
Super User
Super User

i am little bit confused by what you asking for.  can you provide an example of what the correct answer would look like?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Certainly! Will export the Data in excel to better view the problem:

I need to get the one product that has values (in this case, Foo Caarousel), and take its Views value to give it to every other product (that doesnt have views), which is atma, aura, etc.
Currently, it stands as:

tone_radeu_0-1705519449687.png

But i need it to be like this:

tone_radeu_1-1705519490330.png

 

 

you could create a measure like this

 

views =
CALCULATE ( SUM ( 'tablename'[views] ), ALL ( tablename ) )





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




That would work if it was a singular [Component] in the matrix, but there are 1 more Component that acts like this, and have its own Carousel (with its views) to fill in the empty values of its products.

tone_radeu_0-1705520720021.png


I tried creating a test table to fill in the empty values, mut something is acting up and it is not working 😞

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors