Forum Discussion
Dax correction
| 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 |
9 Replies
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.
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))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.
Hi,
Why are you using the ALL() function there? Why not just this?
=CALCULATE( COUNTROWS ( VW_Holiday_details)
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
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.
- CALCULATE( COUNTROWS ( VW_Holiday_details ),ALL(VW_Holiday_details)) --this is also gives 16 rows.
Hi JothiG
We would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.
Thank you.
