Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
NormandoSanchez
New Member

Measure calculation using row context

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 

 

   .......

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.