Forum Discussion

BhagyashriM42's avatar
BhagyashriM42
Frequent Visitor
4 years ago
Solved

Calculated column- percentage using different columns

Hello Community,   I want to calculate a calculated column where it will give the % of particular categories as given in the screenshot,I have tried using earlier function to get count of "Happy" a...
Need Help
SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

BhagyashriM42 if I understood what you need then creare this calculated column:

 

Pct from Category and Age-Group = 
VAR _current_category = 'Table'[Category]
VAR _current_age_group = 'Table'[Age-Group]
VAR _current_kpi = 'Table'[KPI]
VAR _num = 
	COUNTROWS(
		FILTER('Table', 
		'Table'[Category] = _current_category 
			&& 'Table'[Age-Group] = _current_age_group 
				&& 'Table'[KPI] = _current_kpi
		)
	)
VAR _denum = 
	COUNTROWS(
		FILTER('Table', 
		'Table'[Category] = _current_category 
			&& 'Table'[Age-Group] = _current_age_group
		)
	)
VAR _result = DIVIDE(_num, _denum)
RETURN
	_result

 





      

Showcase Report – Contoso By SpartaBI