Forum Discussion

JothiG's avatar
JothiG
Helper III
6 months ago
Solved

Dax correction

CALCULATE( COUNTROWS ( VW_Holiday_details) ,ALL(VW_Holiday_details[fin_year])) --this dax is not working correctly   -- result should be 19 rows but result is 16 rows .  sample data here div_c...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    6 months ago

     

    Hi JothiG , I have tried. It is picking 19 records.

     

krishnakanth240's avatar
krishnakanth240
Super User
6 months ago

Hi JothiG 

 

If your intention is to count all rows ignoring all filters, then remove field [fin_year] from ALL argument and check the count.

 

  • JothiG's avatar
    JothiG
    Helper III
    6 months ago
    CALCULATE( COUNTROWS ( VW_Holiday_details ),ALL(VW_Holiday_details)) --this is also gives 16 rows.
    • krishnakanth240's avatar
      krishnakanth240
      Super User
      6 months ago

       

      Hi JothiG , I have tried. It is picking 19 records.