Dax Target Measure

[Kauto2007]

Hi 

I've got 3 years worth of data visaulised in a line chart for expenditure. Im wanting to create a measure for a target that shows what 3.2% of the total amount would be per month. It's based on payroll so there's multiple different categories of payroll but just want 3.2% of the total to show each month, this would then be dynamic with whatever department the the user chooses in the slicer.

exmaple of 1 month data is :

Team	Category	Total
A	X	250000
A	Y	125000
A	Z	325000
B	X	175000
B	Y	225000
B	Z	110000
C	X	115000
C	Y	225000
C	Z	310000

[v-zhouwen-msft · Accepted solution]

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @Kauto2007 ,

If I understand you wrong, please correct me and show the expected result in pictures.

The Table data is shown below:

Use the following DAX expression to create a measure

Measure = SUM('Table'[Total]) * 0.032

Final output

Best Regards,
Wenbin Zhou

[Ray_Minds · Accepted solution]

Hi @Kauto2007 
1. Import the data into PowerBi Desktop
2. Create Measure for Total
# Total = SUM('Table'[Total])
3. Calculate the 3.2% of the Total
3.2 % Of Total = [# Total]* 0.032
4. Add the level Slicer based on the Requirement

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[v-zhouwen-msft · Accepted solution]

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @Kauto2007 ,

If I understand you wrong, please correct me and show the expected result in pictures.

The Table data is shown below:

Use the following DAX expression to create a measure

Measure = SUM('Table'[Total]) * 0.032

Final output

Best Regards,
Wenbin Zhou

[lbendlin]

Please provide sample data that fully covers your issue, including year and month.
Please show the expected outcome based on the sample data you provided.