Team, Earlier I was using Excel table and below mentioned solution was working fine I switched to Dataverse table with same field and not able to get count on 'Text Label', I can see the count If I hover the mouse on "With" function but the value is not assigning to a Text label.
With(
{
wData:
Filter(
TableDataverse,
IsMale = 0
)
},
CountRows(
Filter(
wData,
IsIndian = 1
)
)
)
/*
Dataverse Table Example
----------------------------------------------------------
S.No | Name | IsMale | IsIndian |
-----------------------------------------------------------
1 Test1 1 0
2 Test 5 0 1
3 Test 10 1 1
*/