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, ...
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 ) )
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 😞