cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## POWER BI matrix not showing 0

1 ACCEPTED SOLUTION
Community Support

Thanks for the reply from PijushRoy , please allow me to provide another insight:

Hi  @rachel_loh21 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

``````Test =
var _column=SUMX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])),[Value])
return
DIVIDE(SUM('Table'[Value]),_column)+0``````

2. 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

2 REPLIES 2
Community Support

Thanks for the reply from PijushRoy , please allow me to provide another insight:

Hi  @rachel_loh21 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

``````Test =
var _column=SUMX(FILTER(ALL('Table'),'Table'[Month]=MAX('Table'[Month])),[Value])
return
DIVIDE(SUM('Table'[Value]),_column)+0``````

2. 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

Hi @rachel_loh21

To solve this problem, please create and use one measure in place of column

``````% Measure =
IF ( Table[%CT SMT percentage] = BLANK (), 0, Table[%CT SMT percentage] )

or

% Measure =
IF ( HASONEVALUE ( Table[%CT SMT percentage] ), Table[%CT SMT percentage], 0 )``````

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors