Help on measure

Hi  orghn ,

Here are the steps you can follow：

1. Create measure.

My_Price =
var _select=SELECTCOLUMNS('Product',"1",'Product'[ProductName])
var _selectmonth=SELECTEDVALUE('Price'[Month])
return
CALCULATE(SUM('Price'[Price]),FILTER(ALL('Price'),'Price'[Month]=_selectmonth&&'Price'[Product] in _select))

Total_Prod_Price =
SUMX(FILTER(ALL('Price'),'Price'[Product]=MAX('Price'[Product])),'Price'[Price])

2. Result:

According to the slicer, if you select [Lab_Name]=”Lab B”, [Product Name] will show the addition of the data of Prodct E and Product B according to the Product table

If you want to select ABC to appear, you can just select ProdctName=”A”,”B”,”C”.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly