Measure help

[Renjith]

Friends 

Please help me to create the measure basevariation for the below sample data

id	result	flag	basevariation
1	12		6
1	15		3
1	18	y	0
1	21		-3
1	24		-6
2	10		-5
2	15		-10
2	5	y	0
2	20		-15

[amitchandak · Accepted solution]

Try like

cal basevariation = maxx(filter(Sheet1,Sheet1[id]=EARLIER(Sheet1[id]) && Sheet1[flag]="Y"),Sheet1[result]) -Sheet1[result]

Here Sheet1 is my table name.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Renjith]

Thanks Amit

Is there any way to implement the same using Measure Instead of Calculated Column

[amitchandak]

You can try a measure. Use all expect

calculate(max(table[result]),allexcept(table[id]),table[flag]="Y") - max(table[result])

But it is always better to have id in another table

refer :https://community.powerbi.com/t5/Desktop/calculate-category-total-in-table-visualization/td-p/519340

https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758