Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Harrisfil
Helper I
Helper I

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. 

Screenshot.png

 

thank you a lot

3 REPLIES 3
Harrisfil
Helper I
Helper I

Hello ,

Anyone who can help me on that? 🙂

 

thank you

Ritaf1983
Super User
Super User

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.