Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Average with specific conditions

Hi there,   I am just starting to discover PowerBI and it looks promising but I am stuck with a specific problem. I'd like to make a trend analysis for several different regions over four years and...
Need Help
Tutorial Requests
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous

It is not clear of your information, before you provide more details, i would like to give two methods as below.

with this measure, i can calcuate how many years each region give the information

measure-region = CALCULATE(DISTINCTCOUNT(Sheet6[year]),ALLEXCEPT(Sheet6,Sheet6[regions]))

with this measure,   i can calcuate how many years each product give the information

Measure-each product = CALCULATE(DISTINCTCOUNT(Sheet6[year]),ALLEXCEPT(Sheet6,Sheet6[products]))

 

For next steps, please let me know what exactly you want.

 

Best Regards

Maggie