Ho do i put this in DAX? Select sum(Indicator) Total_Loss from Tablewhere Indicator = Total Loss;

[Spoorthi50]

I have thi table :

Month	Indicator	Value $ (mln USD)	Value %	Value Target %
Jan	Total Loss	1.23	0.25%	0.30%
Jan	UNIL	2.3	183.33%	20%
Feb	Total Loss	1.34	0.28%	0.30%
Feb	UNIL	-0.23	-17.11%	20%
Mar	Total Loss	2.32	0.40%	0.30%
Mar	UNIL	1.47	63.26%	20%
Apr	Total Loss	4.57	0.71%	0.30%
Apr	UNIL	3.16	69.20%	20%
May	Total Loss	3.33	0.66%	0.30%
May	UNIL	-1.11	70.11%	20%
Jun	Total Loss	2.31	0.43%	0.30%
Jun	UNIL	-0.24	-18.99%	20%
Jul	Total Loss	3.15	0.67%	0.30%
Jul	UNIL	1.23	60.12%	20%

I wnat to see this in a table visual like this:

Total Loss(%, mln$)
Monthly	YTD	Target
0.25%	0.45%	0.30%
$1.33	$17.57

UNIL(%, mln$)
Monthly	YTD	Target
193.00%	91.00%	20.00%
$2.60	$15.91

How to do it?

[v-eachen-msft]

Hi @Spoorthi50 ,

I don't know how to get values like $1.33 or 193.00%. Would you like to describe the formula or relationship?

[Spoorthi50]

Hi @v-eachen-msft ,

---

@v-eachen-msft wrote:

Hi @Spoorthi50 ,

I don't know how to get values like $1.33 or 193.00%. Would you like to describe the formula or relationship?

---

Monthly column, is the same % and $ values for the selected month. YTD is the cumulative sum till the selected month. Values shown in the smaller table sample are some random numbers.

[v-eachen-msft]

Hi @Spoorthi50 ,

You can not put currency and percentage in the same column because they are different types.

Here is my test file

[Spoorthi50]

Thank you @v-eachen-msft . I tried that as well. But Business wanted to see it in that format only.

Thanks much for your help:).