Hiding measure rows in matrix visual

[commonsenseuser]

Hi all,

I am making a matrix visual and adding measures to the values field in the visualization fields. I only want to show measures with non blank rows. How can I do that? Is there a measure through which I can do it? I would really appreciate feedback on how this can be done or for any other alterntive approach. I have attached my matrix visual aling with the table structure in the images below. The values in the pictures are random and are for illustrative purposes only.

[v-gizhi-msft · Accepted solution]

Hi,

Please take following steps:

1)Create a new calculated table:

Table = 
CROSSJOIN (
    DISTINCT ( SELECTCOLUMNS ( 'Master', "HEAD", Master[ROW 1] ) ),
    DATATABLE (
        "MEASURE", STRING,
        {
            { "Measure 1" },
            { "Measure 2" },
            { "Measure 3" },
            { "Measure 4" }
        }
    )
)

2)Try this measure:

Measure = 
SWITCH (
    SELECTEDVALUE ( 'Table'[MEASURE] ),
    "Measure 1", [Measure 1],
    "Measure 2", [Measure 2],
    "Measure 3", [Measure 3],
    "Measure 4", [Measure 4]
)

3)The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto

[Anonymous]

Please @v-gizhi-msft , could you add again the file? It seems that link is broken. 

Thank you. 

[atramj]

Hi! I can not download pbix. Error NOT FOUND 404.Could you please upload again?

thank you so much

[amitchandak]

@commonsenseuser 

You can create measure with all except, which represent row total and use that as a filter in visual

Refer , how to create:https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

[Pragati11]

Hi @commonsenseuser ,

You must have created calculations for your Measure1, Measure2, Measure3, Measure 4 using DAX calculation.

As you haven't shared formula for your above measures, I can add that, in your measure calculation, try to calculate only NON BLANK results.

If you can share your Measure calculations, it's easy to highlight the change.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[commonsenseuser]

Thank you for the reply. 

Here is a measure that I am using for this matrix:

Measure 1 = CALCULATE(SUM(Master[Value]), FILTER(Master, Master[COLUMN 1] = "Value 1"))