Forum Discussion
Issue with Conditional Measure Removing Category from Matrix Visual
Hi everyone, I'm facing an issue with a conditional measure in my Power BI matrix visual where a specific category ("Site (Cost / Acre)") gets removed when applying dynamic calculations. Here are th...
Thank you Anonymous , let's break it down now.
- You said that the Normalized_Values is what causing Site(Cost/Acre) to go blank. Do any of the conditions in that measure -
- [Group1] = "07. Project Cost (Original), or
- [Group1] = "08. Total" , have corresponding data for the column Site?
- Additionally, are the other measures that you calculated and are throwing into the matrix table, limiting the scope of data that the measure Normalized_Values works on?
Usually these issues arise from what you have in the data and not necessarily because of incorrect DAX. So I would start there. However that is not to say that once you figure out what your data is on a row by row level, your DAX code wont change.
- You said that the Normalized_Values is what causing Site(Cost/Acre) to go blank. Do any of the conditions in that measure -
As a very simple solution first, can you right click "Category" in your rows card and select "Show items with no data"?
I tried that and it does show the category now (see image)
However you can see via the original matrix that there are values there before changing the measure: