Forum Discussion
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.
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?
4 Replies
i am little bit confused by what you asking for. can you provide an example of what the correct answer would look like?
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 ) )
