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

Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!
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

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors