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.
Hi All,
As seen in above screen shot I am able to display total of last column only in a Table. My requirement is like I want to display total of actual contribution% and _FTE.
Please help.
Thanks,
Shraddha.
Solved! Go to Solution.
Dear @Anonymous,
I have an ex with Salary and % Salary of Employee. You can try this step by step:
If you got some problem, delete some data and upload your pbix file. I can solve directly on your pbix file.
Regards,
ManNVSM.
Hi @Anonymous,
The contribution% is a measure in your table visual? What's your formula and resouce table look like? Please share more details for further analysis.
Best Regards,
Angelia
I have a column in my actual table namely Actual Contribution % . I just dragged and drop this column in a Table visual along with other two columns as shown in screenshot. Then just by enabling Total function of Table visual , I get count of _FTE column and displayed respective count. But when same thing I am trying to do with Actual Contribution % column then I am not able to get respective count over there. And suppose I am taking COUNT( Actual Contribution %) after removing count functionality of _FTE then I am able to get count of actual contri%.
So now my actual issue is like I want to dispaly respective counts of both columns . But at a time I am getting count of only 1 column.
Hope now you will understand my main problem.
Please help.
Regards,
Shraddha
Make sure your column has a default summarisation under the modelling tab.
However with % calcs it may be better to have a measure that works correctly at all levels. Measures should total automatically.
Hi @stretcharm,
I need to show count of actual contri % in a place of red mark..
Is it possible to add measure value in table visual where I marked red circle?
Regards,
Shraddha
What data type? Is it Text is the % part of the value? What is default summarization is there in the modelling tab.
Text fields set to Do not summarise don't show totals.
If your data is summarised already to get each row then you have to use the same type of summarisation on the total.
Try creating a computed column or measure that does the same value and see if that works.
Hi @stretcharm
For % part data type is percentage and default summarization is set to don't summarised.
Now I can am able to get count of Actual contri %. but instaed of 0.00% I am getting 1 in front of each project in a table.
So can we get index numbers like 1,2,3,4..... etc instead of 1 1 1??
Dear @Anonymous,
I have an ex with Salary and % Salary of Employee. You can try this step by step:
If you got some problem, delete some data and upload your pbix file. I can solve directly on your pbix file.
Regards,
ManNVSM.
Hi @Anonymous,
This works with me . Thanks a lot 🙂
Hi @Anonymous,
The total value is based on the calculation of each rows above, you want to getting running total right? Could you please share your data table in table format rather than screenshot, and list the expected result, so that we can copy data and try to reproduce.
Best Regards,
Angelia
Hi @Anonymous,
Please try the solution @Anonymous posted, and could you please share the .pbix(delete the sensitive data or create dummy data) for further analysis. If you have resolved your issue, welcome to share your solution or mark the right/helpful reply as answer. More people will benefit from here.
Best Regards,
Angelia
Covering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |