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....
It could be a year, a month or several months.
The % should every always calculated againts the period selected. And for example, if you select 2 o 3 fields against the total revenue, it should ((XAccount + YAccount) / Total Revenue). In that case you have to consider the period selected!
sreyes10 and where you do you select the year month in a slicer?
Yes, in a slicer I select the period that I want to show!
sreyes10 i dont know if this is what you mean but see my file attached.
if you change the slicers, it always rolls up to what you have selected in the slicers.
It seems that work, but there is a way to select just TOTAL REVENUE and sum them?
Because the "TOTAL" is just the TOTAL REVENUE.