Forum Discussion
Microsoft EmployeeCalculate percentages based on different dates granularity
For your case, you'd better use bookmark in power bi.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
and for the total problem, it seems that total of each day in march on first picture is not same as second picture in mar.
If it is a measure total problem?
please see this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907If not your case, please share your sample pbix file and your expected output.
Regards,
Lin
You can use ALLSELECTED instead of ALL to do this.
To make your measure as general as possible (based on your current model), you could write
P Mix =
DIVIDE (
SUM ( Sheet1[Prior Volume] ),
CALCULATE (
SUM ( Sheet1[Prior Volume] ),
ALLSELECTED ( Sheet1[Product Hier], Sheet1[Product Hier lvl 1], Sheet1[Product Hier lvl 2] )
)
)
Using this measure, the denominator would be determined by any slicers filtering the table.
For convenience, it might be better to have a Product table related to your existing table, which would simplify the above measure since you could write ALLSELECTED ( 'Product' ).
MohannadSh1996Anonymous
ALLSELECTED will not solve the problem .. could you please send a more clear query to calculate total by month?
v-lili6-msftCommunity Support
For your case, you'd better use bookmark in power bi.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
and for the total problem, it seems that total of each day in march on first picture is not same as second picture in mar.
If it is a measure total problem?
please see this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907If not your case, please share your sample pbix file and your expected output.
Regards,
Lin
- MohannadSh1996
Hi v-lili6-msft , Thank you for your answer, i do believe that the bookmark is the most suitable solution in my case, but i can't share the pbix file due to the sensentive data that i have.