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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
akhaliq7
Post Prodigy
Post Prodigy

Trying to show 0 in each row of a Matrix Visual

I have a matrix visual, in the row field have sales persons and in the values trying to add a measure, the measure is currently defined as below:

Holidays = 0

But when I add this measure a blank row is returned under sales persons. Can anyone help me with this.
 
FYI: The reason the value is at 0 is because this measure is going to be a placeholder.
 


    

1 ACCEPTED SOLUTION
akhaliq7
Post Prodigy
Post Prodigy

IF(DISTINCTCOUNT('Table'[Department ID]) = 1, 0, BLANK()),

 
Using an if statement and distinctcount has solved my problem

View solution in original post

4 REPLIES 4
Ahmedx
Super User
Super User

pls try this

Measure = LEN(MAX('sales' [persons]))*0

 

akhaliq7
Post Prodigy
Post Prodigy

IF(DISTINCTCOUNT('Table'[Department ID]) = 1, 0, BLANK()),

 
Using an if statement and distinctcount has solved my problem
3CloudThomas
Super User
Super User

I have taken a look at the link above, I don't think this is what I am look for, the article refers to showing rows with no values, but I am not trying to do this instead I want to show a 0 for every row in the department field inside a matrix, this 0 is hardcoded and does not belong to a column and/or table.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.