Matrix Table not displaying blank values

[Harrisfil]

Hi,

I have the following issues.

I have a matrix table where i have categories in Rows and MonthName in Columns.

In values i have multiple dax measures.

in the format section i have toggled to the right the  " Switch values to rows so to have the measures displayed just right on the categories. i need somehow to make non related measures to categories not visible. So in the first category for example to have only the first 3 measures displayed, in the second category the other 3 etc...

Categories is a dim table that is connected with the fact table with the corresponding column.

i have tried to adjust the measure like this with no success:

_Mail_CES% =

VAR MailCESq1 = [__MailCESq1]

VAR MailCESq2 = [__MailCESq2]

RETURN

IF(

    HASONEVALUE(Categories[Categories]) &&

    VALUES(Categories[Categories]) = "Email" &&

    NOT(ISBLANK(MailCESq1)) &&

    NOT(ISBLANK(MailCESq2)),

    DIVIDE(MailCESq1, MailCESq2),

    BLANK()

)
where 

__MailCESq1 = COUNTROWS(FILTER('msfp_questionresponse', AND('msfp_questionresponse'[Response] > "4", 'msfp_questionresponse'[msfp_questionid] = "156CF66A-EEF0-EE11-904C-6045BD895608")))

and 

__MailCESq2 = COUNTROWS(FILTER(msfp_questionresponse, 'msfp_questionresponse'[msfp_questionid] = "156CF66A-EEF0-EE11-904C-6045BD895608"))

im wondering if its possible somehow.

my target it to have in the beginning the YtD column and then the Quarters and Months. it will be by default Current year so no need to have also previous years at all. 

thank you a lot

[Harrisfil]

Hello ,

Anyone who can help me on that? 🙂

thank you

[Ritaf1983]

Hi @Harrisfil 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[Harrisfil]

Hello Rita,  

Thanks for your answer. Sure here you are

https://we.tl/t-92A5kfsDFd

I have attached also an excel file with the desired result.

Thanks again 

Harris