Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
Solved! Go to Solution.
IF(DISTINCTCOUNT('Table'[Department ID]) = 1, 0, BLANK()),
pls try this
Measure = LEN(MAX('sales' [persons]))*0
IF(DISTINCTCOUNT('Table'[Department ID]) = 1, 0, BLANK()),
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.
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |