Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Masters
I am trying to filter my table with DAX and create a new table.
I want to exclude companies from the main table those all factories are Inactive. Below picture; "Company C" should be excluded as all factories of Company C is Inactive. So new table will only have Company A, B and C
Can you please help?
Here, you can see the PBIX file.
https://drive.google.com/file/d/1zxp-Ln_e3Mzmzkefe68h5OWO76kQY2EH/view?usp=sharing
Solved! Go to Solution.
hi @Mercovito ,
Not sure if i fully get you, try to create a calculated table like:
Table =
CALCULATETABLE(
sheet1,
FILTER(
VALUES(sheet1[Company]),
"Active" IN CALCULATETABLE(VALUES(sheet1[Factory Active - Inactive]))
)
)
it worked like:
Table =
FILTER(
DISTINCT( Sheet1[Company] ),
NOT ISEMPTY(
CALCULATETABLE( Sheet1, Sheet1[Factory Active - Inactive] = "Active" )
)
)
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
hi @Mercovito ,
Not sure if i fully get you, try to create a calculated table like:
Table =
CALCULATETABLE(
sheet1,
FILTER(
VALUES(sheet1[Company]),
"Active" IN CALCULATETABLE(VALUES(sheet1[Factory Active - Inactive]))
)
)
it worked like:
Thank you so much; I need to burn my brain to understand this step by step 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
25 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
27 | |
16 | |
14 | |
13 |