Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
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...
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?
i am little bit confused by what you asking for. can you provide an example of what the correct answer would look like?
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:
But i need it to be like this:
you could create a measure like this
views =
CALCULATE ( SUM ( 'tablename'[views] ), ALL ( tablename ) )
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.
I tried creating a test table to fill in the empty values, mut something is acting up and it is not working 😞
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.