Need to create calculated Column for counting values based on selected filters/values

[Steels_Cat]

Hello All, 
I have to create dynamic calculated column or do not know how to call it  - filter "CountFlight" - is a just Calculated column based on this measure - 

CALCULATE(COUNTROWS('table1'),FILTER('Table1','Table1'[Flight]=EARLIER('Table1','Table1'[Flight]))). The main problem is that the client wound like to create a filter based on this column but after i use the filter "Filter Service type" and the date range, for example last 6 months - CountFlights is not equal to TotalFlights (COUNT('Table1','Table1'[Flight]) on the tooltip chart

The logic here is that if i filtered "Scheduled" from Flights Service Type and last 6 months from this row data file should stay only the second row. The filter CountFlights has to show 1 instead of 2. CountFlight filter has to be same as TotalFlights number from the below chart. I tried to use summarized table but client wants to use drill thought, also and from summarized table I’m not able to use it 

[V-lianl-msft]

Hi @Steels_Cat ,

Only measures are dynamic, but measures cannot be used as slicers.

In general, we can create a parameter slicer and change the visual by dynamically passing parameters to measure.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Steels_Cat Columns do not update dynamically, only when the dataset is refreshed.

[Steels_Cat]

Yes, i know but for purpose of the report. I do not know how to call it, this "dynamic calculated column"