Forum Discussion
sreyes10
Helper I
Helper ICreating 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....
vanessafvg
Community Champion
Community Championsreyes10 and where you do you select the year month in a slicer?
sreyes10Helper I
Helper IYes, in a slicer I select the period that I want to show!
- vanessafvg
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.
- sreyes10
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.