Forum Discussion

muhammad_bens's avatar
muhammad_bens
Regular Visitor
2 years ago

Issue with Displaying Correct Values in Matrix Visualization for Grouped Items

Hi Community, I need help with a matrix visualization in Power BI. My dataset includes items grouped under "Crop" which contains "Area_planted" and "Crop_yield." I want to show a ratio (Area_planted...
aduguid's avatar
aduguid
Memorable Member
2 years ago

Give this a try using INSCOPE

 

TheTableMeasure =
	IF (
		ISINSCOPE ( 'balance_sheet'[Items (groups)] ) && 'balance_sheet'[Items (groups)] = "Crop",
		[Crop Ratio],
		[Actual Value Measure]
	)