Dax measure to Count number of categories where the fact value is blank(column from a different table) and replaced on date is blank(column from different table)
Categories(table 1)
Energy
Emission
Water
Waste
Fact(native units) table 2
100
600
Replaced on (table 3)
2022
2023
2021
Expected output for year 2024 is 1 , water native units is missing and its replaced on date is blank
Blank_category = countrows(filter(summarizecolums(category),isblank(fact) && isblank(replaced on)
But replace on field/column is not being recognized
New contributor
puneetha c is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3