Matrix Visualization - Suppress Zero and Missing Rows

[AvPowerBI]

Hi,

I am currently using a Matrix Visualization, I want Suppress Zero and Missing Rows?

Currently all the Rows are showing because of the way the DAX Measure is being calculated and cannot think of an alternative way to deal with this.

Basically I want those Rows to be grouped as blank or Null and appear on the Visuzalization, is this possible?

Thanks

[v-easonf-msft]

Hi, @AvPowerBI 

Could you please tell me whether your problem has been solved?

For now, there is no content of description in the thread.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@AvPowerBI - Perhaps something like:

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(__Calc = 0,BLANK(),__Calc)

Make sure that "Show items with no data" is not turned on anywhere. 

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[v-easonf-msft]

Hi, @AvPowerBI 

Could you  please  share relevant screenshots to further elaborate on your question?

Best Regards,
Community Support Team _ Eason

[amitchandak]

@AvPowerBI , not very clear. Try measure like

if([measure] =0 , blank(), [measure])

if(calculate([measure]) ,allexcept(Table,Table[row])) =0, blank(), [measure]) // row is column on row.

[pranit828]

HI @AvPowerBI 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

from what I understand, I would use

Visual Control = 
var _result = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table','Table'[Category])
)
return
IF(
    _result>0,
    1,0
)

Then,