Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Specify a number from a column

Hi,   I would like to choose a number from a column (WorkingDaysIn Month) in order to use it as a divisor. How can I do it?   TourRunrate = CALCULATE(COUNTROWS(TourTbl)) / *divisor*  
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Assuing you have selected a certain month in the FIlter/slicer, try this

 

=COUNTROWS(TourTbl)/MAX(TourTbl[WorkingDaysInMonth])

 

Hope this helps.