Dax correction

[JothiG]

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_code	date	description	shortdesc	del_status	Holiday_Type	Statecode	fin_year
1	2024-04-19 00:00:00.000	LOK SABHA ELECTION DAY 2024	ELECT	N	N	1	2024
1	2024-05-01 00:00:00.000	MAY DAY	MAY1	N	N	1	2024
1	2024-08-15 00:00:00.000	INDEPENDENCE DAY	AUG15	N	N	1	2024
1	2024-10-02 00:00:00.000	GANDHI JAYANTHI	OCT2	N	N	1	2024
1	2024-10-30 00:00:00.000	DEEPAVALI	DEEPA	N	F	1	2024
1	2024-10-31 00:00:00.000	DEEPAVALI	DEEPA	N	F	1	2024
1	2024-11-01 00:00:00.000	DEEPAVALI	DIWAL	N	F	1	2024
1	2025-01-14 00:00:00.000	PONGAL	PONGA	N	F	1	2024
1	2025-01-15 00:00:00.000	PONGAL	PONGA	N	F	1	2024
1	2025-01-26 00:00:00.000	REPUBLIC DAY	REPUB	N	N	1	2024
1	2025-04-14 00:00:00.000	TAMIL NEW YEAR	TAMIL	N	F	1	2025
1	2025-05-01 00:00:00.000	MAY DAY	MAY 1	N	N	1	2025
1	2025-08-15 00:00:00.000	INDEPENDENCE DAY	AUG24	N	N	1	2025
1	2025-10-02 00:00:00.000	GANDHI JAYANTHI	OCT2	N	N	1	2025
1	2025-10-20 00:00:00.000	DEEPAWALI	DEEPA	N	F	1	2025
1	2025-10-21 00:00:00.000	DEEPAWALI	DEEPA	N	F	1	2025
1	2026-01-15 00:00:00.000	PONGAL	PONGA	N	F	1	2025
1	2026-01-16 00:00:00.000	PONGAL	PONGA	N	F	1	2025
1	2026-01-26 00:00:00.000	REPUBILC DAY	JAN26	N	N	1	2025

[v-karpurapud]

Hi @JothiG 

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @krishnakanth240 , @Ashish_Mathur and @pcoley  for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution?If you have any more questions, please let us know and we’ll be happy to help.

Regards,

Microsoft Fabric Community Support Team

[Ashish_Mathur]

Hi,

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

=CALCULATE( COUNTROWS ( VW_Holiday_details)

[pcoley]

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]

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.

[krishnakanth240]

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.

[krishnakanth240]

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]

CALCULATE( COUNTROWS ( VW_Holiday_details ),ALL(VW_Holiday_details)) --this is also gives 16 rows.

[krishnakanth240]

 

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