Forum Discussion
Solved
Using CALCULATE when filter removes all data
I got the following example Provider Project Licitation Order 1 A X 1 1 A - 2 1 B Y 3 2 B - - 2 B Z - 3 A - 4 3 C - 5 3 C - 6 And i wa...
jgtirz Maybe 3 measures:
# of PROJECTS = COUNTROWS('Table') + 0 # of LICITATIONS = COUNTROWS(FILTER('Table',[Licitation]<> "-")) + 0 # of ORDERS = COUNTROWS(FILTER('Table',[Order] <> "-")) + 0
jgtirz Maybe 3 measures:
# of PROJECTS = COUNTROWS('Table') + 0
# of LICITATIONS = COUNTROWS(FILTER('Table',[Licitation]<> "-")) + 0
# of ORDERS = COUNTROWS(FILTER('Table',[Order] <> "-")) + 0
Cheers mate, that "+0" did the trick!
