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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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