cancel
Showing results for
Did you mean:
Helper II

## How to get 0 to show in values instead of nothing in a Matrix Visual?

Hello,

I am currently making a matrix visual with a value assiociated with a person and a month, however, in the months that show no data I cannot get the matrix visual to show a 0. I have tried using:

measure = 'table[column]' + 0

and

Measure = if(isblank('table[column],0,[column]))

but niether fix the problem, they still show no value at all when i use the new measure instead of the original column in the 'Values' section of the visual.

I think this may be because there are no 0 values in the underlying table for the column in question?

Thanks in advance, matrix in question pictured below.

1 ACCEPTED SOLUTION
Helper II

Thank you for your response, I have tried it using the sum function and that did not work either.

Can I ask what you mean by dimension table and star schema?

Thanks

3 REPLIES 3
Community Support

Hi  @benmcmahon ,

I created some data:

Fact Table:
It contains all the primary keys of the dimension and associated facts or measures(is a property on which calculations can be made) like count of items, total sales, average of sales etc.
Dimension Tables:
Dimension tables provides descriptive information for all the measurements recorded in fact table.
Dimensions are relatively very small in comparison of fact table.

A fact table holds the data to be analyzed, and a dimension table stores data about the ways in which the data in the fact table can be analyzed.

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema?source=docs

Here are the steps you can follow：

1. Create calculated table.

``````Table 2 =
DISTINCT('Table'[Group])``````

2. Join relationship between two tables

3. Create measure.

``````Measure =
COUNT('Table'[ID]) +0``````

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User

@benmcmahon , hopefully, the measure is like

measure = sum('table[column]') + 0

+0 works best when you date, agent etc come from the dimension table and you are in star schema.

But some missing combination it will not work

Helper II

Thank you for your response, I have tried it using the sum function and that did not work either.

Can I ask what you mean by dimension table and star schema?

Thanks

Announcements