Forum Discussion
Creating a Sum Measure Conditionally (Revenue vs Another Accounts)
Dear Power BI Experts, I'm trying to create a New Measure where I have a constant value which is the Revenue. My idea is to find what is the percentage of each accounting cell against the Revenue....
Sure.
This is one of my tables.
I have 15 segments with the same data, connected by date and segments.
https://1drv.ms/x/s!AvyeYvlLZCLPnnr-55SOZdHTCR--
Thank you
sreyes10 would you filter on the date in a slicer? if so you can use this
% of Total2 = CALCULATE(DIVIDE(sum(Query1[Value]), CALCULATE(sum(Query1[Value]), ALLSELECTED(Query1))))I will filter the period and the account that I want to know the %.
There is a way to select just the rows "TOTAL REVENUE" and sum them?
sreyes10 explain to me what you are trying to achieve and maybe i can be more helpful around the actual solution.
What are you trying to do and why sort thing.