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.

     

pcoley's avatar
pcoley
Super User
6 months ago

please try CALCULATE( COUNTROWS ( VW_Holiday_details) ,ALL(VW_Holiday_details)) 
And if you want to keep filters from other viz:
CALCULATE( COUNTROWS ( VW_Holiday_details) ,ALLSELECTED(VW_Holiday_details))

pcoley's avatar
pcoley
Super User
6 months ago

I think you have some other filters pointing your viz. to remove all filters please try with this formula:

CALCULATE( COUNTROWS ( VW_Holiday_details) ,ALL()) 

I hope this helps. if so please mark it as a solution. kudos are welcome.