I am struggling with DAX Measure to Countif on Measure Result in condition.
Count of Items whose result of Measure4 = 0 for the selected Sales Centre and Month (YearMonthNumber).
I am trying with this measure
=CALCULATE (COUNTA (Data [Item Name]), FILTER(ALL('Data'), [QualificationUpto20] = 0))
and
=COUNTAX (FILTER ('Data’, [QualificationUpto20] =0), [Item Name])
but getting wrong result.
Desired result is shown in attached images/ file.Note: My actual data source is SQL Server Table. In attached image the data is for just sample. I have used Excel Power Query to load and group data. I want the desired result via Dax measure instead of Custom column in Power Query or Calculated Column in Data modeling to because those options cause slow speed in data refresh. I also want to keep query folding in power query.
DAX Measure to Countif on Measure Result in condition.xlsx
Count of Items whose result of Measure4 = 0 for the selected Sales Centre and Month (YearMonthNumber).
I am trying with this measure
=CALCULATE (COUNTA (Data [Item Name]), FILTER(ALL('Data'), [QualificationUpto20] = 0))
and
=COUNTAX (FILTER ('Data’, [QualificationUpto20] =0), [Item Name])
but getting wrong result.
Desired result is shown in attached images/ file.Note: My actual data source is SQL Server Table. In attached image the data is for just sample. I have used Excel Power Query to load and group data. I want the desired result via Dax measure instead of Custom column in Power Query or Calculated Column in Data modeling to because those options cause slow speed in data refresh. I also want to keep query folding in power query.
DAX Measure to Countif on Measure Result in condition.xlsx
