Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Kauto2007
Regular Visitor

Dax Target Measure

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 :

 

TeamCategoryTotal
AX250000
AY125000
AZ325000
BX175000
BY225000
BZ110000
CX115000
CY225000
CZ310000
2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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:

vzhouwenmsft_0-1724118346647.png

Use the following DAX expression to create a measure

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

Final output

vzhouwenmsft_1-1724118487447.png

vzhouwenmsft_2-1724118498400.png

 

Best Regards,
Wenbin Zhou

View solution in original post

Ray_Minds
Continued Contributor
Continued Contributor

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


Ray_Minds_0-1724245284399.pngRay_Minds_1-1724245308370.png

 

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.

View solution in original post

3 REPLIES 3
Ray_Minds
Continued Contributor
Continued Contributor

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


Ray_Minds_0-1724245284399.pngRay_Minds_1-1724245308370.png

 

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.

Anonymous
Not applicable

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:

vzhouwenmsft_0-1724118346647.png

Use the following DAX expression to create a measure

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

Final output

vzhouwenmsft_1-1724118487447.png

vzhouwenmsft_2-1724118498400.png

 

Best Regards,
Wenbin Zhou

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.