Specify a number from a column

[Anonymous]

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*

[Ashish_Mathur]

Hi,

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

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

Hope this helps.

[Anonymous]

[Interkoubess]

Hi @Anonymous,

What number do you want to pick up?

Please give example with you screen shot and I can make a try.

Thank you.

Ninter