Forum Discussion

JothiG's avatar
JothiG
Icon for Helper III rankHelper 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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 months ago

Hi,

Why are you using the ALL() function there?  Why not just this?

=CALCULATE( COUNTROWS ( VW_Holiday_details)