Forum Discussion
error with VALUES
Hi Lexey,
The issue here is your aggregation level, using the all fact table to make your percentage when you add several columns from your table it will give you the total cost divided by all the slice and dices so not 100% per column. Because you are making it at a Jobs level you need to calculated it at that level so you need to change your percentage to:
Procentage = CALCULATE([total cost] / CALCULATE([total cost]; ALL('fact'[jobs])))Other issue is Budget value you are making a sumX of the plan and then multiplying that sumx by the porcentage on SUMX the calculations are made line by line and then summed so you need to calculate for each cost line the percentage value and then do the sum you need to change it to:
Values of budget = SUMX(plan;plan[plan] * [Procentage])
See result am PBIX file below:
Regards,
MFelix
Hi Lexey,
What is the full extent of your data in terms of te pivot table? What are the columns you are using to get the final visual only Jobs and buildings or something else also?
Regards,
MFelix
A strange thing was with PBI! I certainly copied this table from another page and for some reason it caught a cache, repeated everything on the new page and everything worked as it should!
thanks again for your help
Hi Lexey,
Nice to hear please mark the correct answer so that other can be helped also.
Regards,
MFelix
ок.
one more question, please. my work is divided into subtypes. if I choose one of the types on a separate slicer, then on the filtered table I get 100% for this group of works and also 100% of the budget. How can I fix the initially calculated percentage and the value of the budget. Thanks