Measure and KPI with Determined Column Data

[BlueSol]

I am new to this. Here is the best way I can describe what I am trying to do.

I want to use KPI and Guage Visualization and have the Target value based off a particular product.
I have a table With Dates, Machine type (Low, Med, high), Product names, and Values
I have two slicers. One for Machine Type and One for Product Names.
I have made a column to use as my target in the Guage and KPI - TargetProduct = SUMX (CALCULATETABLE('DataPPT', 'DataPPT'[Product Name]="TestProd"),[Values])

My issue is My TargetProduct only works if I have it ALSO selected in Slicer and then it Sums the two products for the guage.

I want the Sum of selected product and Target Value of TargetProduct to compare the two.

And with KPI I want to use TargetProduct as my Target Goal but run into same issue.

Any direction on how to do this properly would be apprciated.

[v-yulgu-msft]

Hi @BlueSol,

Rather than creating a column to use as target value in the Guage and KPI, you could create a measure like below:

TargetProduct measure = SUMX (CALCULATETABLE('DataPPT', 'DataPPT'[Product Name]="TestProduct"),[Value])

Regards,
Yuliana Gu

[BlueSol]

By doing the second data set.  As my baseline changes it was easier for making a selection then creating a new measure each time.

[BlueSol · Accepted solution]

Seems it was easier for now to create another table with my baseline data and add the same two filters and use second data set as target values. second data set is copy of first.