Forum Discussion
Helper INeed to create calculated Column for counting values based on selected filters/values
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
3 Replies
- Greg_Deckler
Community Champion
Steels_Cat Columns do not update dynamically, only when the dataset is refreshed.
Steels_CatYes, i know but for purpose of the report. I do not know how to call it, this "dynamic calculated column"
V-lianl-msftCommunity Support
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.
