Forum Discussion
Helper IHow can I filter a column by another column?
Hi,
I am rookie on PBI.
I have a measure that first I want the find the all column values [Arr_Airport_Code] in a table that has blank value [frequency] in two months earlier. And than I want to this filtered column's all frequencies. But I can not show the whole year frequency of the values that just two months earlier's frequencys are blank.
Here is my measure. Thanks
Hi akay23 ,
Maybe you can try REMOVEFILTER('table'[Time Series]). I used to recommend that you use allexcept() to keep the fields you want to keep the filter, all other filters will be removed. You can try it.
Or you can try creating a new table via values('table'[Time Series]) and there no relationship between these tables. Add this field to a slicer, Filter OAG_Deneme_Veri or other tables by passing values as string from the new table. This can be cumbersome, but it allows you to filter a field individually without affecting other fields that you don't need to filter.
Best Regards
Community Support Team _ chenwu zhu
10 Replies
- VahidDM
Super User
Hi akay23
Can you post sample data as text and expected output?
Not enough information to go on;
please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
akay23Carrier code Dep Airport Code Arr Airport Code Frequency Time Series AB ABC XYZ 0 1.01.2018 AB ABC XYZ 0 1.02.2018 AB ABC XYZ 0 1.03.2018 AB ABC XYZ 0 1.04.2018 AB ABC XYZ 0 1.05.2018 AB ABC XYZ 0 1.06.2018 AB ABC XYZ 0 1.07.2018 AB ABC XYZ 0 1.08.2018 AB ABC XYZ 13 1.09.2018 AB ABC XYZ 14 1.10.2018 AB ABC XYZ 15 1.11.2018 AB ABC XYZ 16 1.12.2018 AB ABC DFG 16 1.01.2018 AB ABC DFG 16 1.02.2018 AB ABC DFG 16 1.03.2018 AB ABC DFG 16 1.04.2018 AB ABC DFG 16 1.05.2018 AB ABC DFG 16 1.06.2018 AB ABC DFG 16 1.07.2018 AB ABC DFG 16 1.08.2018 AB ABC DFG 0 1.09.2018 AB ABC DFG 0 1.10.2018 AB ABC DFG 16 1.11.2018 AB ABC DFG 16 1.12.2018 This is my raw data example. When I select 01/08/2018 on time slicer, I want to data below.
Carrier code Dep Airport Code Arr Airport Code Frequency Time Series AB ABC XYZ 5 1.01.2018 AB ABC XYZ 6 1.02.2018 AB ABC XYZ 7 1.03.2018 AB ABC XYZ 8 1.04.2018 AB ABC XYZ 9 1.05.2018 AB ABC XYZ 10 1.06.2018 AB ABC XYZ 0 1.07.2018 AB ABC XYZ 0 1.08.2018 AB ABC XYZ 13 1.09.2018 AB ABC XYZ 14 1.10.2018 AB ABC XYZ 15 1.11.2018 AB ABC XYZ 16 1.12.2018 When I select a month on date slicer in my visual. Which [Dep Airport Code] is open and what is these airport codes sum frequency by month.
I hope this example make you clear thank you
- VahidDM
How can find which [Dep Airport Code] is open? and how did you calculate the Frequency numbers in the result table:
Can you add more details?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
