topic Re: Dax Target Measure in DAX Commands and Tips

Dax Target Measure

Kauto2007 — Wed, 14 Aug 2024 09:10:03 GMT

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

Re: Dax Target Measure

lbendlin — Wed, 14 Aug 2024 22:37:17 GMT

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.

Re: Dax Target Measure

Anonymous — Tue, 20 Aug 2024 01:48:37 GMT

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

Re: Dax Target Measure

Ray_Minds — Wed, 21 Aug 2024 13:02:06 GMT

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.