Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi;
I am try to calculate a measure NumDaysOpenShop, in a Period Year/Month and in a Shop or in all shops
LIke page filters i have got a Year and a Shops, in the year i can select only one, in the shop i can select one, some or all shops.
In matrix i show year/month on rows
2022 Measure be SUM([Table][Colum]) with dates in 2022 and shop selected in page filter, except if all or more than one shop is selected, in this case i want use MAX(measure [NumDaysInMonth] with dates in 2022
January SUM([Table][Colum]) with dates in January 2022 and shop selected in page filter, except if all or more than one shop is selected, in this case i want use MAX(measure [NumDaysInMonth] with dates in 2022
Hope i explained
.......
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |