Forum Discussion

Harrisfil's avatar
Harrisfil
Helper I
1 year ago

Matrix Table not displaying blank values

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

Need Help
Show and Tell
Tips and Tricks

3 Replies