Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
above shown column is determine by the two other columns in same table. when comes to total of the column, all the precentages were aggregating. how do i show the precentage of the total column?
Solved! Go to Solution.
If your data is in a table called TestData, first column is called FIRST, and second called SECOND, you need three measures:
Total First = SUM(TestData[First]) Total Second = SUM(TestData[Second]) Percentage = DIVIDE([Total First],[Total Second],0)
Drop those three measures into a table or matrix.
You could probably do this in one measure, but the above makes it clear what is going on, and it means you have 100% explicit measures in your table, which you should.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYour ROI measure should be something like = DIVIDE (numerater, denominator, alternate result if denominator is zero)
then put that in your table. In the total row, it won't add the percentages, but divide the total numerator by the total of the denominator.
If you need more specific help, post a sample of the data and a more complete picture of the visual.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
i need to get this highlighted one
If your data is in a table called TestData, first column is called FIRST, and second called SECOND, you need three measures:
Total First = SUM(TestData[First]) Total Second = SUM(TestData[Second]) Percentage = DIVIDE([Total First],[Total Second],0)
Drop those three measures into a table or matrix.
You could probably do this in one measure, but the above makes it clear what is going on, and it means you have 100% explicit measures in your table, which you should.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingi have try this and for some its working but for some its not.
You are going to need to provide your full data. What I provided works for the snippits, but you have something else going on in your model that I am not accounting for, and I cannot guess based on a few screen caps pasted in the post.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |